When you use variables in update statement and update the columns with the values of variables which keep on changing for each row , you can simulate many things that are done using Loop or a Cursor declare @temp table ( product_name varchar ( 100 ),...( read more)

Two UK SQL Server user group dates to flag up for anyone with an interest in BI:

• Integrating Data Mining into your BI Solution, with Allan Mitchell, on June 4th via Live Meeting
  http://www.sqlserverfaq.com/events/177/Inte...Full Article.