I wrote a little blog post on something similar as an example of using a recursive CTE (https://devondba.blogspot.com/search?q=Create+a+table+of+dates+showing+holidays+and+workdays), works quite well to build up a calendar table.

Brilliant!

Fantastic to see what else can be done with SQL, thank you so much for sharing.

Hi Wolfgang

Thanks for the reply. I've checked the default trace and the only time anything was done on this database was when I ran an alter statement to fix the...

Hi folks

I've just seen this happen, the application went haywire and starting logging errors of

"The definition of object 'my_stored_procedure' has changed since it was compiled."

This isn't something I've ever...

I think the query re-write will be enough but I'll post back if not, thanks again for your help, very much appreciated .

As Erland Sommarskog says, DBCC FREEPROCCACHE will indeed clear the plan in question and all others; be careful with the use of it and not good on production and from...

Thanks again Erland and sorry for the miss wording of the dead lock issue. I'll try and get the trace up tomorrow.

Have a great weekend.

I believe dropping an index will cause any execution plans that use that index to be recompiled on the next run as the index is no longer valid. As you...

Thank you very much for the reply. That's a valid point, I missed the check to see if the update was needed.

The deadlock is happening on the clusterd index....

Hi adelinetfl.smkss

GPO is correct, you can up the value for max recursion. The value of 100 is kind of a built in protection to stop endless recursion.

I did a quick...

Thank you for you reply. I've had a good stab at it and eventually found the info needed within the windows server log. Thanks though.

Thanks Gail, makes perfect sense when explained that way.

Thanks again.

Hi all

I have a similar issue so I though a more in depth description may help vineetbhargav too.

I have a proc that is used in a report. The report has...

Ok Gail I'll take a look at the application and see if things can be improved/altered there.

Thanks again, very much appreciated!

Thank you for the prompt reply. If I were to do that, just so I understand for the future, which order would I put the second two columns in (as...