I was unable to find 'Microsoft SQL Server 2005 - 9.00.4060.00 (X64)' listed.

Any ideas where I can download service pack?

If anyone is interested I have the solution:

I am populating results of the query in a post in a #temp1 table and then workign off it.

SELECT [TimeValue/DateValue]=CASE WHEN GROUPING(DateValue)=0

...

Thank you so much. It works perfectly. At times we tend to look for a complicated solution to a simple problem.

Thanks again,

Natasha

Greg & Steve,

Thank you for suggestions and spending time analyzing do & dont's. I have decided to go with Greg's suggestion of scheduling job and keep my logic in...

Thank you for the suggestion. I kind of like the idea of a separate schedule that will fire only one day of the month.

Any ideas on how to pass the...

Steve,

Thank you for your response. I am already doing that in my job steps.

If @Today = @CallSpDate

Call Stored Proc

Else Raise error

I was looking for an elegant way to schedule...

Thank you to both of you. I was thinking the same that using if then else will be more efficient than case since case does not use indexes and majority...

Bob,

Thank you for your response and a better solution. My code to check holiday function is already posted in my first posting.

Thanks again,

Natasha

Never mind. My code is working. If anyone is interested here is the code. If you have a better solution/ suggestion I am interested in that too.

declare

@day datetime,

@Rtn int,

@LoopCount int,

@DayWeek...