[thelist] [SQL] Can I Do This?

[Jacques Capesius]

> Getting each month its own row is the easy part. What I'm 
> having trouble
> with is making a sorta dynamic select list that would allow for
> arbitrarily many subjects. Is there any way to do this within a SQL
> Statement, or are we looking at me having to whip up a fancy-pants
> stored procedure to handle something like this?
 

Q: This is not necessarily trivial, depending on your database... Which
one are you using?

A: SQL Server 2000