quote:

---

Originally posted by Itzon

Hopefully this helps, my table is pretty large because it contains all of our timesheet entries, but i only need a few.
I have Table [TIME] with
[Tim_emp] [nvarchar] (8)
[Tim_wrkhrs] [decimal] (8,2)
[Tim_payrate] [decimal] (12,4)
[Tim_wrkdate] [datetime]
[Tim_type] [nvarchar] (10)

Entries are made daily. I need billed amount (payrate * wrkhrs) for each time type in a given date range (wrkdate between ? AND ?). Daily entries would look like this

Tim_emp Tim_wrkhrs Tim_payrate Tim_wrkdate Tim_type
004 2.5 15.00 9/1/2011 MGMT
004 5.5 15.00 9/1/2011 MKTG
005 8.0 25.50 9/1/2011 MGMT
006 6.0 25.75 9/1/2011 D
006 2.0 25.75 9/1/2011 MKTG

I'd need to eventually show this for the selected date range:
Tim_emp MGMT MKTG D
004 (2.5 * 15) (5.5 * 15) 0
005 (8 * 25.5) 0 0
006 0 (2 * 25.75) (6*25.75)

---

select 
	Tim_emp
	,max(case when Tim_type='MGMT' then Tim_wrkhrs*Tim_payrate else 0 end) as MGMT
	,max(case when Tim_type='MKTG' then Tim_wrkhrs*Tim_payrate else 0 end) as MKTG
	,max(case when Tim_type='D' then Tim_wrkhrs*Tim_payrate else 0 end) as D
from #TIME
group by Tim_emp 

select Tim_emp,MGMT,MKTG,D
from (select Tim_emp,Tim_wrkhrs * Tim_payrate as wrkrate,Tim_type
from #TIME)t
PIVOT(SUM(wrkrate) FOR Tim_type IN (MGMT,MKTG,D))p