Skip to content

Instantly share code, notes, and snippets.

@NPS-ARCN-CAKN

NPS-ARCN-CAKN/unpivot.sql

Created May 26, 2015 19:21
Show Gist options
  • Save NPS-ARCN-CAKN/9c91fcb7fc5de27c97f8 to your computer and use it in GitHub Desktop.
Save NPS-ARCN-CAKN/9c91fcb7fc5de27c97f8 to your computer and use it in GitHub Desktop.
Download ZIP
Example of an UNPIVOT query
Raw
unpivot.sql
use ARCN_Sheep
SELECT Survey, LegacyUnitID, Category, n
FROM [CompositionCountsByUnit]UNPIVOT (n FOR Category IN (Ewes, EweLike, Lambs, Rams_LessThanFullCurl, Rams_FullCurl, UnclassifiedRams, UnclassifiedSheep,
Yearlings, Rams1_2Curl, Rams3_4Curl, Rams7_8Curl, Rams1_4Curl, Rams_GT_7_8Curl)) u;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment