Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Group Rows into One Row With Multiple Columns
Glenn, it works! Thanks a lot! Here's another solution someone else provided me SELECT MAX(Q1) AS Q1, MAX(Q2) AS Q2, MAX(Q3) AS Q3, MAX(Q4) AS Q4, Group_Name, ScheduledYear FROM v_GroupSchedule GROUP BY Group_Name, ScheduledYear- tkepongo
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Group Rows into One Row With Multiple Columns
Is it possible to group multiple rows with multiple columns into a single row? For example with the code below, I would like to create a view to make it look like: -- Q1 ------ Q2 ------ Q3 ------ Q4 ----- Group ---Year Audit Info|**Null***|**Null***| Audit Info|Accounting| 2011...- tkepongo
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
