Name Date Duration
------ ------------------------------ ---------------------------------------
Leiuck 02/23/2014 12.50
Annver 02/24/2014 8.00
Leiuck 02/24/2014 9.00
Mauler 02/24/2014 8.00
Shaman 02/24/2014 4.00
Annver 02/25/2014 8.00
Leiuck 02/25/2014 8.50
Mauler 02/25/2014 8.00
Shaman 02/25/2014 6.00
Annver 02/26/2014 8.00
Leiuck 02/26/2014 8.50
Shaman 02/26/2014 7.00
Annver 02/27/2014 8.00
Shaman 02/27/2014 6.00
我需要按日期排列的列,并将持续时间作为结果。
select
Name = left( per.Name, 3) + right( per.Name, 3)
, Date = convert( varchar, t.EntryDate, 101)
, Duration = sum(t.Duration)
from tentry t (nolock)
left join tpers per (nolock) on t.PersonID = per.PersonID
where
t.EntryDate >= dateadd(wk, datediff(wk, 0, getdate()) -0, -1)
and t.EntryDate <= dateadd(wk, datediff(wk, 0, getdate()) -0, 5)
and per.Division = 1
and per.Act = 1
group by
per.Name
, t.EntryDate
请帮忙。
更多信息...
我需要的输出结果类似于这样。非常感谢您的帮助。
Name 2/23/2014 2/24/2014 2/25/2014 2/26/2014 2/27/2014
Annver 8 8 8 8
Leiuck 12.5 9 8.5 8.5
Mauler 8 8
Shaman 4 6 7 6
PIVOT
查询。 - Hart CO