multiple records into a variable

• shalabh.sachdeva

  SSC-Addicted

  Points: 422

  More actions

  April 13, 2009 at 3:43 am

  #201917

  Is there any possibility for a single variable to hold multiple row data from a table having a finite number of columns as a string, if not using cursors or recordset ?

• shiniti

  Old Hand

  Points: 351

  More actions

  March 5, 2010 at 9:55 pm

  #1129560

  Hello !! How are you doing ?

  I hope this article can help you in your question.

  http://www.sqlservercentral.com/scripts/Variables/63345/

  Best Regards!

  Shin-Iti.