با استفاده از دستور Pivot می توان از داده های سطر ها به عنوان ستون استفاده کرد:

جدول زیر را در نظر بگیرید:

SELECT  ID, LoadStateID, HourID, Value
FROM    HourlyLoadState

حالا ساعت ها را بجای ردیف در ستون نمایش می دهیم:

select LoadStateID
  , [1] as Hour1, [2] as Hour2, [3] as Hour3, [4] as Hour4
  , [5] as Hour5, [6] as Hour6, [7] as Hour7, [8] as Hour8
  , [9] as Hour9, [10] as Hour10, [11] as Hour11, [12] as Hour12
  , [13] as Hour13, [14] as Hour14, [15] as Hour15, [16] as Hour16
  , [17] as Hour17, [18] as Hour18, [19] as Hour19, [20] as Hour20
  , [21] as Hour21, [22] as Hour22, [23] as Hour23, [24] as Hour24
from
(
  select LoadStateID,HourID,Value
  from HourlyLoadState
) x
pivot
(
  max(Value)
  for HourID in([1],[2],[3],[4], [5], [6],[7],[8],[9],
                [10],[11],[12],[13],[14],[15], [16],
                [17],[18],[19],[20],[21],[22],[23],[24])
)p

و خروجی به صورت زیر می شود:

همچنین با استفاده از UnPivot می توان از ستون ها به عنوان سطر استفاده کرد:

جدول زیر را در نظر بگیرید:

SELECT  ID, Hour1, Hour2, Hour3, Hour4
FROM    Test

حالا ساعت ها را بجای ستون در ردیف نمایش می دهیم:

select ID,
  IndicatorName,
  IndicatorValue
from Test
unpivot
(
  IndicatorValue
  for IndicatorName in (Hour1, Hour2, Hour3, Hour4)
) u;