SQL Master

Seems to be easy question. And many of you may be already knew 2-3 ways of doing it. Here is the query I use normally to get the all the dat...

Unlike PIVOT which de-normalizes the data, UNPIVOT is more helpful in getting your data back to a more normalized form. UNPIVOT performs t...

In one of my previous posts I talked about Calculating Running Totals in T-SQL .  Now I will show you how you can calculate the running tota...

In Sql Server 2005 and 2008 you can script the stored procedure in Management Studio by right clicking on Store Procedure name and clicking ...

In one of my previous posts I wrote about “ How to Create a Comma Delimited List ”.  Now I’ll show you an example with reverse action, that ...