Trouble creating a view in SQL
Posted on 2011-02-10
I am trying to create a view, I seem to be getting an error when I am trying to convert a string to a numeric field. I do not know what is missing. when I execute the query I seem to be getting the same error.
CREATE VIEW SALES_TRANSFERS AS
SELECT p21_view_audit_trail_customer_1307.column_changed, p21_view_audit_trail_customer_1307.date_created, p21_view_audit_trail_customer_1307.key2_cd, p21_view_audit_trail_customer_1307.key2_value, CONVERT(decimal,p21_view_audit_trail_customer_1307.key1_value)
where p21_view_audit_trail_customer_1307.column_changed = 'class_5id'
Msg 4511, Level 16, State 1, Procedure SALES_TRANSFERS, Line 3
Create View or Function failed because no column name was specified for column 5.
THESELECT STATEMENT IS ALL ON THE SAME LINE