troubleshooting Question

SQL script to convert Calendar

Avatar of Michael Katz
Michael KatzFlag for United States of America asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008SQL
6 Comments1 Solution376 ViewsLast Modified:
I guess its really hard to explain what I am looiking at...

CalCentury  CalYear  CalMonth  CalDay1  CalDay2  CalDay3   CalDay4......CalDay31
20                 11            1            0                0             1                    1
20                 11            2            1                1             1                    1

These represent Days of the Week per month, per year, Per Century..

The 0 in each CalDay Column represent NonWorking Days while the 1 is a WorkingDay

How can I get my data to  look like this   Where 2011= Year, 01 = month ,01 = Day
Date         WorkDay
20110101     1
20110102     0

Hopefully this makes sense
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros