0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs

CREATE TABLE #yt
    ([Store] int, [Week] int, [xCount] int)
;
    
INSERT INTO #yt
    ([Store], [Week], [xCount])
VALUES
    (102, 1, 96),
    (101, 1, 138),
    (105, 1, 37),
    (109, 1, 59),
    (101, 2, 282),
    (102, 2, 212),
    (105, 2, 78),
    (109, 2, 97),
    (105, 3, 60),
    (102, 3, 123),
    (101, 3, 220),
    (109, 3, 87)
;


select *
from 
(
  select store, week, xCount
  from #yt
) tar
pivot
(
  sum(xcount)
  for week in ([1], [2], [3])
) piv;

fork query

edited aug 14

created nov 18 16 anonymous