tag:blogger.com,1999:blog-56545971557823014402024-02-08T07:54:47.628-08:00SQL WishlistVishal Gadhiahttp://www.blogger.com/profile/10405776476868114249noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-5654597155782301440.post-31629368533519383412009-06-02T13:45:00.000-07:002009-06-02T14:14:32.192-07:00SQL Server : Query / T-SQL Script to find out Starting and Ending Dates of Daylight Saving for Current YearI have worked on lots of complex queries and tasks that invloved extensive programming and logic to be embedded into the SQL Sever T-SQL code.
<br />While for one of the applications in early 2007, that I was working on in India, I had to get the daylight saving dates for that year. But during that time, we did not implement that functionality. While I was working on this problem, I tried to google and find out what could be a possible in-built function in SQL Sever to give me this result. I could not find any such kind of fucntion nor I could not find any one writing about this problem.
<br />I decided to start my own blogs and start writing and helping the community and start learning from my peers, and the first thing that came to my mind was this unsolved problem that I had faced in early 2007. To my surprise, I did not find any solution to this problem and decided that this problem will be my first article to blog.
<br />Please find the Query / T-SQL script below.
<br />
<br /><span style="font-size:78%;">
<br /><head><meta equiv="Content-Type" content="text/html; charset=windows-1252"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="DECLARE_files/filelist.xml"><title>DECLARE @CurrentDate AS DATETIME</title><!--[if gte mso 9]><xml> <o:documentproperties> <o:author>xx02491</o:Author> <o:template>Normal</o:Template> <o:lastauthor>xx02491</o:LastAuthor> <o:revision>1</o:Revision> <o:totaltime>1</o:TotalTime> <o:created>2009-06-02T21:11:00Z</o:Created> <o:lastsaved>2009-06-02T21:12:00Z</o:LastSaved> <o:pages>1</o:Pages> <o:words>302</o:Words> <o:characters>1723</o:Characters> <o:company> NRADNEWELLCO</o:Company> <o:lines>14</o:Lines> <o:paragraphs>4</o:Paragraphs> <o:characterswithspaces>2021</o:CharactersWithSpaces> <o:version>11.8107</o:Version> </o:DocumentProperties></xml><![endif]--><!--[if gte mso 9]><xml> <w:worddocument> <w:spellingstate>Clean</w:SpellingState> <w:grammarstate>Clean</w:GrammarState> <w:punctuationkerning/> <w:validateagainstschemas/> <w:saveifxmlinvalid>false</w:SaveIfXMLInvalid> <w:ignoremixedcontent>false</w:IgnoreMixedContent> <w:alwaysshowplaceholdertext>false</w:AlwaysShowPlaceholderText> <w:compatibility> <w:breakwrappedtables/> <w:snaptogridincell/> <w:wraptextwithpunct/> <w:useasianbreakrules/> <w:dontgrowautofit/> </w:Compatibility> <w:browserlevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument></xml><![endif]--><!--[if gte mso 9]><xml> <w:latentstyles deflockedstate="false" latentstylecount="156"> </w:LatentStyles></xml><![endif]--><style><!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";}@page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;}div.Section1 {page:Section1;}--></style><!--[if gte mso 10]><style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}</style><![endif]--></head>
<br /><body lang="EN-US" style="'tab-interval:.5in'">
<br /><div class="Section1">
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@CurrentDate <span style="'color:blue'">AS</span> <span style="'color:blue'">DATETIME<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@CurrentYear <span style="'color:blue'">AS</span> <span style="'color:blue'">INTEGER<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@FirstDateInMarch <span style="'color:blue'">AS</span> <span style="'color:blue'">DATETIME<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@FirstDateInNovember <span style="'color:blue'">AS</span> <span style="'color:blue'">DATETIME<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@FirstDayInMarch <span style="'color:blue'">AS</span> <span style="'color:blue'">VARCHAR</span><spanstyle='color:gray'>(</span>20<span style="'color:gray'">)<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@FirstDayinNovember <span style="'color:blue'">AS</span> <span style="'color:blue'">VARCHAR</span><spanstyle='color:gray'>(</span>20<span style="'color:gray'">)<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@MarchDateAddValue <span style="'color:blue'">AS</span> <span style="'color:blue'">INTEGER<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@NovDateAddValue <span style="'color:blue'">AS</span> <span style="'color:blue'">INTEGER<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@DayLightBeingDate<span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>AS</span> <span style="'color:blue'">DATETIME</span> <spanstyle='color:green'>-- 2nd Sunday of March<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>DECLARE</span><spanstyle='font-size:10.0pt;font-family:"courier>@DayLightEndDate<span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>AS</span> <span style="'color:blue'">DATETIME</span> <spanstyle='color:green'>-- 1st Sunday of Nov<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:1'> </span><o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier>@CurrentYear <span style="'color:gray'">=</span> <span style="'color:fuchsia'">DATEPART</span><spanstyle='color:gray'>(</span>YY<span style="'color:gray'">,</span><spanstyle='color:fuchsia'>GETDATE</span><span style="'color:gray'">())<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>--SELECT @CurrentYear = 2010<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:1'> </span>@FirstDateInMarch <span style="'color:gray'">=</span><span style="'color:fuchsia'">CONVERT</span><span style="'color:gray'">(</span><spanstyle='color:blue'>DATETIME</span><span style="'color:gray'">,</span><spanstyle='color:red'>'03/01/'</span><span style="'color:gray'">+</span><spanstyle='color:fuchsia'>CONVERT</span><span style="'color:gray'">(</span><spanstyle='color:blue'>VARCHAR</span><span style="'color:gray'">(</span>4<spanstyle='color:gray'>),</span>@CurrentYear<span style="'color:gray'">)),<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:2'> </span>@FirstDateInNovember <spanstyle='color:gray'>=</span> <span style="'color:fuchsia'">CONVERT</span><spanstyle='color:gray'>(</span><span style="'color:blue'">DATETIME</span><spanstyle='color:gray'>,</span><span style="'color:red'">'11/01/'</span><spanstyle='color:gray'>+</span><span style="'color:fuchsia'">CONVERT</span><spanstyle='color:gray'>(</span><span style="'color:blue'">VARCHAR</span><spanstyle='color:gray'>(</span>4<span style="'color:gray'">),</span>@CurrentYear<spanstyle='color:gray'>))<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier>@FirstDateInMarch<span style="'color:gray'">,</span>@FirstDateInNovember<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier> <o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:2'> </span>@FirstDayInMarch<spanstyle='mso-tab-count:1'> </span><span style="'color:gray'">=</span> <spanstyle='color:fuchsia'>DATENAME</span><span style="'color:gray'">(</span>w<spanstyle='color:gray'>,</span>@FirstDateInMarch<span style="'color:gray'">),<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:2'> </span>@FirstDayInNovember <spanstyle='color:gray'>=</span><span style="'mso-spacerun:yes'"> </span><spanstyle='color:fuchsia'>DATENAME</span><span style="'color:gray'">(</span>w<spanstyle='color:gray'>,</span>@FirstDateInNovember<span style="'color:gray'">)<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier>@FirstDayInMarch<span style="'color:gray'">,</span>@FirstDayInNovember<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier>@MarchDateAddValue<span style="'mso-tab-count:1'"> </span><spanstyle='color:gray'>=</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>CASE</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>WHEN</span> @FirstDayInMarch <span style="'color:gray'">=</span><span style="'color:red'">'SUNDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 14<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayInMarch <span style="'color:gray'">=</span><span style="'color:red'">'MONDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 13<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayInMarch <span style="'color:gray'">=</span><span style="'color:red'">'TUESDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 12<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayInMarch <span style="'color:gray'">=</span><span style="'color:red'">'WEDNESDAY'</span> <span style="'color:blue'">THEN</span>11<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayInMarch <span style="'color:gray'">=</span><span style="'color:red'">'THURSDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 10<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayInMarch <span style="'color:gray'">=</span><span style="'color:red'">'FRIDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 9<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayInMarch <span style="'color:gray'">=</span><span style="'color:red'">'SATURDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 8<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:8'> </span><spanstyle='color:blue'>END</span><span style="'color:gray'">,<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:2'> </span>@NovDateAddValue<spanstyle='mso-tab-count:1'> </span><span style="'color:gray'">=</span><spanstyle='mso-tab-count:1'> </span><span style="'color:blue'">CASE</span><spanstyle='mso-tab-count:1'> </span><o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayinNovember <span style="'color:gray'">=</span><span style="'color:red'">'MONDAY'</span><span style="'mso-tab-count:2'"> </span><spanstyle='color:blue'>THEN</span> 6<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayinNovember <span style="'color:gray'">=</span><span style="'color:red'">'TUESDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 5<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayinNovember <span style="'color:gray'">=</span><span style="'color:red'">'WEDNESDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 4<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayinNovember <span style="'color:gray'">=</span><span style="'color:red'">'THURSDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 3<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayinNovember <span style="'color:gray'">=</span><span style="'color:red'">'FRIDAY'</span><span style="'mso-tab-count:2'"> </span><spanstyle='color:blue'>THEN</span> 2<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayinNovember <span style="'color:gray'">=</span><span style="'color:red'">'SATURDAY'</span><span style="'mso-tab-count:1'"> </span><spanstyle='color:blue'>THEN</span> 1<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:10'> </span><spanstyle='color:blue'>WHEN</span> @FirstDayinNovember <span style="'color:gray'">=</span><span style="'color:red'">'SUNDAY'</span><span style="'mso-tab-count:2'"> </span><spanstyle='color:blue'>THEN</span> 0<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:8'> </span><spanstyle='color:blue'>END<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier> <o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:2'> </span>@MarchDateAddValue<spanstyle='color:gray'>,<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:2'> </span>@NovDateAddValue<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier> <o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:2'> </span>@DayLightBeingDate <spanstyle='color:gray'>=</span> <span style="'color:fuchsia'">DATEADD</span><spanstyle='color:gray'>(</span>dd<span style="'color:gray'">,</span>@MarchDateAddValue<spanstyle='color:gray'>,</span>@FirstDateInMarch<span style="'color:gray'">),<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><spanstyle='mso-tab-count:2'> </span>@DayLightEndDate <spanstyle='color:gray'>=</span> <span style="'color:fuchsia'">DATEADD</span><spanstyle='color:gray'>(</span>dd<span style="'color:gray'">,</span>@NovDateAddValue<spanstyle='color:gray'>,</span>@FirstDateInNovember<span style="'color:gray'">)<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier>@DayLightBeingDate<span style="'color:gray'">,</span>@DayLightEndDate<o:p></o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier>SELECT</span><spanstyle='font-size:10.0pt;font-family:"courier> <spanstyle='color:fuchsia'>DATENAME</span><span style="'color:gray'">(</span>dw<spanstyle='color:gray'>,</span>@DayLightBeingDate<span style="'color:gray'">),</span><spanstyle='color:fuchsia'>DATENAME</span><span style="'color:gray'">(</span>dw<spanstyle='color:gray'>,</span>@DayLightEndDate<span style="'color:gray'">)<o:p></o:p></span></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal" style="'mso-layout-grid-align:none;text-autospace:none'"><spanstyle='font-size:10.0pt;font-family:"courier><o:p> </o:p></span></p>
<br /><p class="MsoNormal"><span style="'font-size:10.0pt'"><o:p> </o:p></span></p>
<br /></div>
<br /></body>
<br /></html></span>
<br />
<br /><span style="font-size:130%;">I hope this post shall be useful to all the user looking out for similar kind of scripts.</span>
<br /><span style="font-size:130%;">Please feel free to leave your comments for the script.</span>
<br />Vishal Gadhiahttp://www.blogger.com/profile/10405776476868114249noreply@blogger.com0