How to loop through each column in cursor recordset

[WayneGretzky]

How can I loop through each field in the current record in a cursor?

I need to essentially do 2 loops. One loops through each record and then inside each record row, I want to perform an insert on each column.

Something like this maybe using a cursor or something else:

For each record in my table (I'll just use the cursor)
For each column in current record for cursor
perform some sql based on the current column value
Next
Next

I guess I just want to know how to do the for each column to cycle through each field in the current cursor's record.

 

[JarlH]

What's your database API? (JDBC, ODBC, embedded SQL...?)

 

[WayneGretzky]

ODBC - SQL Server 2005

 

[WayneGretzky]

I need to do this in a stored proc using Transact SQL functions, cursors, etc., not using VB or other UI languages.

 

[WayneGretzky]

This will be a sql statement in SQL Server 2005 Integration Services...so it's all in the backend using T-SQL

 

[r937]

I need to do this in a stored proc using Transact SQL functions, cursors, etc.

you may wish to try one of the Microsoft SQL Server forums, of which this isn't one




r937.com | rudy.ca

 

[WayneGretzky]

what's the URL do you have it handy?

 

[Golom]

forum183 is the Microsoft SQL Server: Programming forum.