List/Grid

Tag Archives: Group

Grouping a set of rows – SQL Server

Consider you have a scenario, where you want to count rows by group of a number(say 5) or you may want to group first 5 rows, then next 5 rows…. Read more »

Pivoting Data in SSRS – SQL Server

Consider we have table like Declare @table Table ( Name varchar(100), Year int, Factor int ) insert into @table values (‘Lucky’,2001,12) insert into @table values (‘Lucky’,2002,13) insert into @table values… Read more »