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.

If you want to know the last Backup/Restore date of database, use the following --Last Backup date of database --Method 1 In Management Studio,Expand database,Right Click on the database and click properties Refer Last Batabase Backup which is availalbe...( read more)

It may be very useful if we have feature to take backup or restore a table I have posted my suggestion here Table level Backup/Restore What do you think of it?...( read more)

One of the users asked this question in the SQL forum I have data in the text as follows AccountNo: 00234543 AccountName: Kickser City: Chicago Country:USA AccountNo: 00234543 AccountName: Annis City: Seatle Country:USA AccountNo: 12234456 AccountName...( read more)

I do quite a lot of work in Switzerland: I lived in Basel for three years and still have a lot of friends and business contacts there as a result. I'll be there next week, in fact, and while I'm there I'll be speaking at the May meeting of the Swiss PASS chapter in Zurich. I'll be doing the same session I did at PASS Europe last week (so no prep time needed, luckily) on 'Designing Effective Aggregations in SSAS 2008'. All the details are here: