Re: Combine multiple records into single row

I've never done it myself. I just found the examples and tried them
and they worked. If you're dealing with too big of a dataset then it
may be tedious.

I've found some more that are more dynamic. Here's the google search
string I used:

pivot table sql server

Cheers,
Jason Lepack

On Mar 29, 2:07 pm, "franzey" <fran...@xxxxxxxxx> wrote:
Thanks for the link. I do only have SQL Server 2000 so the PIVOT is
out. Looks like I will be doing some CASE statements. I'm new at this.
Do you know the general syntax I would use using the above example to
get this rolling?

On Mar 29, 1:15 pm, "Jason Lepack" <jlep...@xxxxxxxxx> wrote:



Examples:http://builder.com.com/5100-6388_14-6143761.html

PIVOT will only work if you have SQL SERVER 2005 otherwise you will
use the CASE method.

- Show quoted text -- Hide quoted text -

- Show quoted text -


.