TSQL Query Pivoting -
I have a table structure as follows:
Holiday Int Course IDID Int Cross INT Distance INT Low Index INT HighIndex INT Sequence INT (representing the sequence of holes: 1, 2, 3, ... 18)
This course has 18 holes .
I want to pivot in:
Hole, 1, 2, 3, ... 18 cross, x, x, x, ... x distance, Y, Y, Y, ... Y LowIndex, Z, Z, Z, ... Z high index, A, A, A, ... A
I curs it Can I use it but in any better way?
TSQL stands for axis. For example, look and see.
Comments
Post a Comment