Need to split date for each quarter 1

[see123]

Here is my Initial data

Name Date Bonus
ABC 1/1/2004 200
ABC 1/4/2004 200
ABC 1/7/2004 200
ABC 1/10/2004 200
ABC 1/2/2004 200
ABC 1/5/2004 200
ABC 1/8/2004 200
ABC 1/11/2004 200

I want to make this data to display like this

Name QTR1_2004 QTR2_2004 QTR3_2004 QTR4_2004
abc 400 400 400 400

Any Ideas please.......

 

[gmmastros]

Not exactly what you were looking for, but....

Set DateFormat DMY
Declare @Temp Table(Name VarChar(10), Date DateTime, Bonus Int)

Insert Into @Temp Values('ABC','1/1/2004 ',  200)
Insert Into @Temp Values('ABC','1/4/2004 ',  200)
Insert Into @Temp Values('ABC','1/7/2004 ',  200)
Insert Into @Temp Values('ABC','1/10/2004',  200)
Insert Into @Temp Values('ABC','1/2/2004 ',  200)
Insert Into @Temp Values('ABC','1/5/2004 ',  200)
Insert Into @Temp Values('ABC','1/8/2004 ',  200)
Insert Into @Temp Values('ABC','1/11/2004',  200)

Select Name, 
       DateAdd(Quarter, DateDiff(Quarter, 0, Date), 0) As Quarter,
       Sum(Bonus)
From   @Temp
Group By Name, DateAdd(Quarter, DateDiff(Quarter, 0, Date), 0)

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom