View Single Post
  #3 (permalink)  
Old October 17th, 2005, 09:33 PM
robprell robprell is offline
Friend of Wrox
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts

My thoughts are the requestor appears to have an infinite possible number of rows in the results. The solution he was forwarded to assumes a finite number of rows. I would argue this is a bad idea from the start. Question is why do you want to do that? What your looking at is a pivot table that you can do in Excel but is not practical in SQL if its not a finite number of columns.