Home All Groups Group Topic Archive Search About
Author
23 Jul 2005 4:56 AM
quest
How do I select records and insert those selected records into another table
with store procedure ?  Any idea ? Thanks.

Author
23 Jul 2005 6:00 AM
Roji. P. Thomas
INSERT INTO <targettable>
(<olumnlist>)
SELECT <olumnlist>
FROM SourceTable

--
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com


Show quote
"quest" <anonym***@microsoft.com> wrote in message
news:uF4GrK0jFHA.3148@TK2MSFTNGP09.phx.gbl...
> How do I select records and insert those selected records into another
> table
> with store procedure ?  Any idea ? Thanks.
>
>
>
Author
23 Jul 2005 3:38 PM
Vinod Kumar
Encapsulate using INSERT INTO SELECT Option ...

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Show quote
"quest" <anonym***@microsoft.com> wrote in message
news:uF4GrK0jFHA.3148@TK2MSFTNGP09.phx.gbl...
> How do I select records and insert those selected records into another
> table
> with store procedure ?  Any idea ? Thanks.
>
>
>

AddThis Social Bookmark Button