> I am new to the idea of using CURSORs in SQL Server but would like some
> input.
> From an efficiency standpoint, which is a better choice?
>
> select query + cfloop + insert query
>
> or
>
> stored procedure using a cursor to do row by row inserts
How does the select look? Usually it is possible to do:
INSERT INTO table (fields)
SELECT fields
FROM othertable
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
