Thanks

Hi,

Thanks for the reply, it would work except that I'm using SQL 2000, so unfortunately, I don't have the PIVOT keyword functionality yet.

I've tried another approach, maybe you'd like...

Hi Phil,

Thanks for the response.

BOL = Books On Line, right? I'm searching them now. Thanks.

Perfect. Exactly what I need.

Thanks!

Joshua