Looping through fields in a cursor

• gregk

  Newbie

  Points: 8

  More actions

  April 29, 2003 at 5:38 am

  #101454

  I have a cursor looping through the records of a derived table (or temporary table), I now need to loop through the individual fields in each record... how can this be done... or better yet, can you use COL_NAME(OBJECT_ID('table_name'), @counter) on a temporary table??? and how???

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  April 29, 2003 at 6:52 am

  #455665

  COL_NAME can be used to retrieve the column names of temporary tables using following syntax.

  USE TEMPDB

  SELECT COL_NAME(object_id("tempdb..#temp_table"),2)

  where #temp_table is the name of temporary table. The above sql returns 2nd column name.

  Hope this helps

• gregk

  Newbie

  Points: 8

  More actions

  April 29, 2003 at 6:57 am

  #455667

  Thank you!!! That was a lot less painful than I imagined!