change cursor code to set based code

[Andrew J. Kelly]

INSERT INTO TableA (Col1, Col2...)
SELECT Col1,Col2... FROM TableB


--

Andrew J. Kelly
SQL Server MVP


"Andrea Worley" <k_rage@hotmail.com> wrote in message
news:089901c34559$5c6cb5a0$a001280a@phx.gbl...

> Is there a way to insert a SELECT statement result into an
> existing table in a stored proc? Currently, I do a select
> statement to get the data I want, then I use a cursor to
> walk through the records, inserting each one into a log
> table. I can't use a view and DTS to append these records
> because I hard code some values and there is an autonumber
> in the table I am inserting to.
>
> So, is there a way to use a view and DTS even with these
> factors? Or is there a way to append the SELECT results
> in a stored proc without using cursors? I'm just trying
> to find a more efficient method. Thank you.

[Andrea Worley]

Thanks so much. It's the simple things that get you
sometimes. That worked perfectly.

>-----Original Message-----
>INSERT INTO TableA (Col1, Col2...)
> SELECT Col1,Col2... FROM TableB
>
>
>--
>
>Andrew J. Kelly
>SQL Server MVP
>
>
>"Andrea Worley" <k_rage@hotmail.com> wrote in message
>news:089901c34559$5c6cb5a0$a001280a@phx.gbl...

>> Is there a way to insert a SELECT statement result into

an

>> existing table in a stored proc? Currently, I do a

select

>> statement to get the data I want, then I use a cursor to
>> walk through the records, inserting each one into a log
>> table. I can't use a view and DTS to append these

records

>> because I hard code some values and there is an

autonumber

>> in the table I am inserting to.
>>
>> So, is there a way to use a view and DTS even with these
>> factors? Or is there a way to append the SELECT results
>> in a stored proc without using cursors? I'm just trying
>> to find a more efficient method. Thank you.

>
>
>.
>