-
Not specified
select 'CT'+'|'+COMPANY+'|'+CONTA CTNAME+'|'+CONTACTTYPE+'|'+CONVERT (CHAR(10),CONTACTADDRESS)
+'|'+PHONE+'|'+FAX+'|'+TIT LE INTO TEMP30
from v3
this query doesn't put the records in the temp30 table and it gives the follwing error:
Msg 8155, Level 16, State 1
No column name was specified for column 1 of 'TEMP30'.
and when I try to give the name to the first column it gives the same error
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|