General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008 R2
>>>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?
>>>
>>
>>Why not just have a character field that contains a string 180+ characters long that contains your bit pattern, ex. "0000110111101". Then just use string functions to determine if they're set or not?
>
>Or just six integers, one for each month, and then use bittest() to see which days are ticked.
But that doesn't cover the cases where you have months with more than 32 days... such as in the case of a quintuple leapyear. <g>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only