Select and Insert

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.

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.
>
>
>

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.
>
>
>