I'm currently running SQL Server 2008 and trying to get the following subquery data:
ID | Field Name | Field Selection
1 | Rating 1 | Good
1 | Rating 2 | Good
1 | Rating 3 | Bad
2 | Rating 1 | OK
Grouped into a single row based on the ID column:
ID | Rating 1 | Rating 2 | Rating 3
1 | Good | Good | Bad
2 | OK | NULL | NULL
Is this possible? Thanks in advance!
Cheers,
Si
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…