May 18, 2015 at 7:42 am
I inherited a report that counts patient visits per month. Holidays are hard coded into the query. What is the best way to handle holidays without hardcoding?
May 18, 2015 at 7:59 am
I would recommend a calendar table.
http://www.sqlservercentral.com/articles/Test-Driven+Development/71075/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 18, 2015 at 8:03 am
I'm using a calendar table but, it doesn't identify holidays.
May 18, 2015 at 8:07 am
NineIron (5/18/2015)
I'm using a calendar table but, it doesn't identify holidays.
I would either update that calendar table so it does identify holidays, or create a Holidays table.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 18, 2015 at 8:10 am
K. Thanx.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply