Hi Chris,

Thanks for ur solution.

Guarav

Hi guys,

I ve' developed the solution for the same. it is as follows.

declare @StartDate DateTime, @EndDate DateTime

select @StartDate = @DateStart, @EndDate = @DateEnd

declare @r as bigint, @i as...

Hi Chris,

I wanted the records Group wise(LoginID). Only one row will be generated for one LoginID. Say if i have 3 rows and 4 columns for loginid 2 then one...

Can anybody help me out from this?

Gaurav

Hi,

Thanks for ur reply!

But I am using Sql Server 2000. Is Pivot can be used in Sql Server 2000 as well.

Gaurav