You're likely going to have a problem with fieldnames beginning with numbers. But it also seems like the wrong way.
IMO, a DateTime2 field for the date and a bit field, so you have two fields and many rows.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer