This topic shows how to write Nested loop with table variable instead of cursors. This tutorial will use AdventureWorks database.  DECLARE @COUNTER AS INT DECLARE @TOTALREC AS INT DECLARE @RESULT_TABLE TABLE ( RES_ID INT, R... [More]

Recently, I created a report using SSRS and i found ROW_NUMBER() can be very useful in rank-related tasks.Here is a sample query using AdventureWorks database. Select ProductID, ReorderPoint , SafetyStockLevel,ROW_NUMBER() OVER (order by ProductID) as RowFROM Production.Product&n... [More]

The PIVOT operator can be used to transform a set of rows into columns while the UNPIVOT operator complements the PIVOT operator by allowing you to turn columns into rows. The following sample will use AdventureWorks database.Sample CodeUSE AdventureWorks GOSELECT DaysToManufacture, sum(StandardCost... [More]