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?