>Hi
>I need to create a table with 2 character fields ( field1, field2 ) then fields of BIT type, default to 0 (false) , named
>[0501], [0502] [0503].....and up to [1029], [1030], [1031]
>Where 0501 represents May 1, etc... ( format mmdd)
>Is there some way to program sql server to build this?
>
>Thanks
>Jaime
Sounds like you're looking for dynamic pivot. How are you going to consume that table? It may be easier to produce such result in SSRS.
If it's not broken, fix it until it is.
My Blog