>I am using MSSQL7 and put the following code in a SP to create a table based on some columns from an already existing table.
>
>Select
>Convert(int,'0000') as cvi_company ,
>Convert(Char(9),'Unknown') as cvi_vendor ,
>Convert(Char(15),'xxxxxxxxxxxxxxx') as cvi_edi_nbr ,
>AP Invoice.Invoice Number
>From DevFWap.AP Invoice
>Into DEVFWap.apcinvoice
>
>I get an error "Incorrect Syntax near '.'"
>
>Huh? Help?
I believe the "Into" clause goes before the From. I guess it's different from the VFP Select .. Into SQL statement. Oh wait! this is not the VFP forum..
You would need create table permissions for this to work.
HTH