454 calendar script - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

454 calendar script

Author

Topic

shiji
Starting Member

2 Posts

Posted - 2012-02-08 : 00:11:42

Can somebody please help to create a 454 calendar script.
Thanks in advance.
Regards,
Shiji

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-02-08 : 01:12:38

what is the expected result ?

KH
[spoiler]Time is always against us[/spoiler]

shiji
Starting Member

2 Posts

Posted - 2012-02-08 : 01:43:22

Please provide the sql script to generate 454 calendar according below format.

Month Qtr Year Week Wk_Start_date WK_End_Date
201001 20101 2010 Week 1 31-JAN-10 06-FEB-10
201001 20101 2010 Week 2 07-FEB-10 13-FEB-10
201001 20101 2010 Week 3 14-FEB-10 20-FEB-10
201001 20101 2010 Week 4 21-FEB-10 27-FEB-10
201002 20101 2010 Week 5 28-FEB-10 06-MAR-10
201002 20101 2010 Week 6 07-MAR-10 13-MAR-10
201002 20101 2010 Week 7 14-MAR-10 20-MAR-10
201002 20101 2010 Week 8 21-MAR-10 27-MAR-10
201002 20101 2010 Week 9 28-MAR-10 03-APR-10
201003 20101 2010 Week 10 04-APR-10 10-APR-10
201003 20101 2010 Week 11 11-APR-10 17-APR-10
201003 20101 2010 Week 12 18-APR-10 24-APR-10
201003 20101 2010 Week 13 25-APR-10 01-MAY-10
201004 20102 2010 Week 14 02-MAY-10 08-MAY-10
201004 20102 2010 Week 15 09-MAY-10 15-MAY-10
201004 20102 2010 Week 16 16-MAY-10 22-MAY-10
201004 20102 2010 Week 17 23-MAY-10 29-MAY-10
201005 20102 2010 Week 18 30-MAY-10 05-JUN-10
201005 20102 2010 Week 19 06-JUN-10 12-JUN-10
201005 20102 2010 Week 20 13-JUN-10 19-JUN-10
201005 20102 2010 Week 21 20-JUN-10 26-JUN-10
201005 20102 2010 Week 22 27-JUN-10 03-JUL-10
201006 20102 2010 Week 23 04-JUL-10 10-JUL-10
201006 20102 2010 Week 24 11-JUL-10 17-JUL-10
201006 20102 2010 Week 25 18-JUL-10 24-JUL-10
201006 20102 2010 Week 26 25-JUL-10 31-JUL-10
201007 20103 2010 Week 27 01-AUG-10 07-AUG-10
201007 20103 2010 Week 28 08-AUG-10 14-AUG-10
201007 20103 2010 Week 29 15-AUG-10 21-AUG-10
201007 20103 2010 Week 30 22-AUG-10 28-AUG-10
201008 20103 2010 Week 31 29-AUG-10 04-SEP-10
201008 20103 2010 Week 32 05-SEP-10 11-SEP-10
201008 20103 2010 Week 33 12-SEP-10 18-SEP-10
201008 20103 2010 Week 34 19-SEP-10 25-SEP-10
201008 20103 2010 Week 35 26-SEP-10 02-OCT-10
201009 20103 2010 Week 36 03-OCT-10 09-OCT-10
201009 20103 2010 Week 37 10-OCT-10 16-OCT-10
201009 20103 2010 Week 38 17-OCT-10 23-OCT-10
201009 20103 2010 Week 39 24-OCT-10 30-OCT-10
201010 20104 2010 Week 40 31-OCT-10 06-NOV-10
201010 20104 2010 Week 41 07-NOV-10 13-NOV-10
201010 20104 2010 Week 42 14-NOV-10 20-NOV-10
201010 20104 2010 Week 43 21-NOV-10 27-NOV-10
201011 20104 2010 Week 44 28-NOV-10 04-DEC-10
201011 20104 2010 Week 45 05-DEC-10 11-DEC-10
201011 20104 2010 Week 46 12-DEC-10 18-DEC-10
201011 20104 2010 Week 47 19-DEC-10 25-DEC-10
201011 20104 2010 Week 48 26-DEC-10 01-JAN-11
201012 20104 2010 Week 49 02-JAN-11 08-JAN-11
201012 20104 2010 Week 50 09-JAN-11 15-JAN-11
201012 20104 2010 Week 51 16-JAN-11 22-JAN-11
201012 20104 2010 Week 52 23-JAN-11 29-JAN-11

Thanks & Regards,
Shiji

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-02-08 : 02:06:35

make use of the F_TABLE_DATE from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519&SearchTerms=F_TABLE_DATE

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources