Monday, October 8, 2012

Unpivot




SELECT [Epoch], [CustomerID], [EdgeNodeID], MediaTypes, Bytes
FROM
   (SELECT top 1000 [Epoch], [CustomerID], [EdgeNodeID], [HTTP], [HTTPS], [WMS], [FMS], [WAC], [WACS]
   FROM [NEW_BandwidthByNodeAggs] (nolock)) p
UNPIVOT
   (Bytes FOR MediaTypes IN
      ([HTTP], [HTTPS], [WMS], [FMS], [WAC], [WACS])
)AS unpvt;
GO

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)