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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Undefined # of column output
I'm looking for a way to do the following in SQL. Let's say we have 3 columns on a table (a, b, c). There is an undefined number of c's per each a, b grouping. If I do a simple select off of the table, I'll get one row of output per each a - b - c combination: a1 b1 c1 a1 b1 c2 a1 b2 c1 a2...
