select question 1

[ArizonaRedneck]

hello. I have 2 databases located on a local SQL server. one is called Store and one is called StoreDevel. My question is how would I select from a table in the Store Database and insert the records into a table int the StoreDevel database? Here's what it looks like so far...

INSERT INTO VendorUPC (VendorID,UPC_Code)

select 33 as VendorID, [UPC Code] as UPC_Code
from Store.BNFusa

Thanks for you help.

-
"Do your duty in all things. You cannot do more, you should never wish to do less." Robert E. Lee

 

[mercwrought]

I think you just have to use their full name

INSERT INTO myserver.mydb.VendorUPC (VendorID,UPC_Code)
select 33 as VendorID, [UPC Code] as UPC_Code
from myserver.Store.BNFusa

something like that

 

[maswien]

try this:

INSERT INTO storedevel.dbo.VendorUPC (VendorID,UPC_Code)
select 33 as VendorID, [UPC Code] as UPC_Code
from Store.dbo.BNFusa

 

[ArizonaRedneck]

Thanks maswien that worked great. I really appreciate it.

-
"Do your duty in all things. You cannot do more, you should never wish to do less." Robert E. Lee

 

[maswien]

Any time, glad it's working.