January 17, 2005 at 11:13 pm
What SQLCode with automatically
APPEND my Item_RTD table to my
existing Items table since both tables
have the same 10 digit char fields ?
SELECT ID, Item
FROM Items
SELECT ID, Item
FROM Items_RTD
I tried to do the following, but
receive a "There is already an object
named ITEMS in the database." error.
SELECT ID, Item
INTO Items
FROM Items_RTD
January 18, 2005 at 12:17 am
INSERT INTO Items (ID, Item)
SELECT ID, Items FROM Items_RTD
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2005 at 5:32 pm
Thanks for the info.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply