|
Hello every one I am trying to create a query for calendar month in the results window. My output should be like and it should be working for every month we execute. can anyone plz suggest me some ideas.
(comments are locked)
|
|
A quick search found this solution: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1173&lngWId=5 by the Exceptional DBA himself, Jeff Moden.
(comments are locked)
|
|
Thank you Thats a really gr8 way to do it. Just was thinking is it possible to do the same thing using a while loop.
(comments are locked)
|

