Posted by franzey on 03/29/07 18:07

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 -

[Back to original message]