Posted by Jason Lepack on 03/29/07 18:27

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...@gmail.com> 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...@gmail.com> 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 -

[Back to original message]