Thanks Yelena,

Even i thought of doing the same, but user was happy with report on one worksheet. Also, i was trying to see, if this is possible in SQL Server...

I tried this using various techniques, but export to same excel on different tab was not possible. I just used a loop in my Stored Procedure, moved all data into...

I know everyone is talking about Holidays For this particular function. but guys don't worry to consider holidays in this is very easy.  I have modified this SQL little bit...