|
-
Mar 1st, 2002, 04:05 PM
#1
Thread Starter
Addicted Member
SQL Server Insert
How can I insert the results of a view into a table which has already been designed and has extra columns in it?
The problem is the extra columns. I tried
INSERT [view] INTO [table]
I also tried to use update. but with no records in the table it would not work. I also tried insert into but that isn't really practical since I have to drop the table to recreate it.
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
|
Click Here to Expand Forum to Full Width
|