Search This Blog

Tuesday, April 17, 2012

Looping through list in SQL

If we have a comma separated list and the requirement is to loop through the list of items one by one or to pass these items to a stored procedure. The easiest and simple way to do this is given below with coments.