create table #temp ( id int, teamid int, userid int, elem...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

create table #temp
(
  id int,
  teamid int,
  userid int,
  elementid int,
  phaseid int,
  effort decimal(10, 5)
)

insert into #temp values (1,1,1,3,5,6.74)
insert into #temp values (2,1,1,3,6,8.25)
insert into #temp values (3,1,1,4,1,2.23)
insert into #temp values (4,1,1,4,5,6.8)
insert into #temp values (5,1,1,4,6,1.5)

select elementid
  , [1] as phaseid1
  , [5] as phaseid5
  , [6] as phaseid6
from
(
  select elementid, phaseid, effort
  from #temp
) x
pivot
(
  max(effort)
  for phaseid in([1], [5], [6])
)p

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results