Insert a recordset into a Table!

[Carlos Rodrigues]

I've this recordset from SQLServer 2000 (same fields - name, type- as a Table).

How can i insert this recorset without using the INSERT INTO ... keyword?
Is there a method to insert an entire recorset into a table?

Thanks in advance!

P.S. - Happy new year!

[DaveSatz]

I think you mean INSERT/SELECT

INSERT table_name
(columns, ....)
SELECT columns, ....
FROM table_name2
--
Thanks,
David Satz
Principal Software Engineer
Hyperion Solutions
->Using SQL Server 7.0 SP2/6.5 SP5a/Cold Fusion 4.5.1/ADO 2.1/VB 6.0/MTS
(Please reply to group only)
-----------------------------------------------------------------

"Carlos Rodrigues" <geograf@geograf.pt> wrote in message
news:3a4cd93c$1@news.devx.com...
>
>
> I've this recordset from SQLServer 2000 (same fields - name, type- as a
Table).
>
> How can i insert this recorset without using the INSERT INTO ... keyword?
> Is there a method to insert an entire recorset into a table?
>
> Thanks in advance!
>
> P.S. - Happy new year!
>