Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Select data Inside as stored Procedure and append to another table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-18 : 09:24:03
Steve Schofield writes "I'd like to know how to do an append query inside a stored proc. Such as in access a person selects one table and and pass the information in an append query to another table. I can get it to work in access but when i do view sql and try that in sql query analyzer it doesn't work. Could you provide just a sample piece of code assuming you have two tables?"
   

- Advertisement -