SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Cliff Corder / 4-4-5 Calendar Functions, Part 2 / Latest Posts

RE: 4-4-5 Calendar Functions, Part 2

ron.carlton 41182 — Thu, 15 Jul 2010 10:20:34 GMT

A table is preferrable for performance reasons. I used a table function because i can pass in what factory location since each of our sites has a different calendar of workdays and holidays; and of course i had to revised it during development several times because the "requirements" kept changing.

RE: 4-4-5 Calendar Functions, Part 2

corder — Mon, 08 Feb 2010 07:35:37 GMT

Using a table is preferable. You'll see better performance out of queries. Something interesting that came up during the comments on Part 1 of the article is performance issues with Date comparisons, especially the BETWEEN operator, and possible ways to increase performance. You might want to check that out.

RE: 4-4-5 Calendar Functions, Part 2

ajhuddy — Sun, 07 Feb 2010 21:01:58 GMT

Thanks for the article. I'm actually working on fiscal based periods at the moment, and have opted to have all of the periods defined in a setup-type table.E.g.Period # | Fiscal Year # | Quarter # | Start Date | End DateThat way, the end-user is responsible to define the fiscal year, and no calculations are required.Your thoughts?

RE: 4-4-5 Calendar Functions, Part 2

corder — Wed, 13 Jan 2010 07:11:41 GMT

Thanks for the comments. It somehow slipped past me that the article was published already. Any other comments are much appreciated.Cliff

RE: 4-4-5 Calendar Functions, Part 2

SQLRNNR — Mon, 11 Jan 2010 11:46:06 GMT

Thanks for taking the time to put together this article.

RE: 4-4-5 Calendar Functions, Part 2

mtassin — Mon, 11 Jan 2010 07:16:19 GMT

Every time I read these articles about 4-4-5 my head hurts... and I vow again and again to make sure to not take a job with a company that follows this practice :)

RE: 4-4-5 Calendar Functions, Part 2

Cem Uney — Mon, 11 Jan 2010 06:41:41 GMT

Thanks for nice article.Also function which returns the Weeks is more usefull for retail programs and like-for-like discussions.As you now sql server's DATEPART weeknumber function does not return the real Week number according to the 4-5-4 calendar...For example if your week starts with Monday. 01/01/2010 Friday02/01/2010 Saturday03/01/2010 Sunday04/01/2010 MondaySql Server returns 1 for weeknumber of 01/01/2010 but it is the 53th week of 2009. Sql Server returns 2 for weeknumber of 04/01/2010 but it is the 1st week of 2010. So the new function should return 2009W53 2010W01anyway thanks again ;)

4-4-5 Calendar Functions, Part 2

corder — Sun, 10 Jan 2010 21:04:24 GMT

Comments posted to this topic are about the item [B]4-4-5 Calendar Functions, Part 2[/B]