Date Calendar

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sean Smith » Date Calendar

41 posts, Page 1 of 5

1 2 3 4 5 »»»

Date Calendar

Rate Topic

Display Mode

Topic Options

Author

Message

Sean Smith-776614

Posted Friday, October 09, 2009 6:20 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 90, Visits: 369

Comments posted to this topic are about the item Date Calendar

Post #800674

Tony Soucie

Posted Thursday, October 29, 2009 6:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:24 PM
Points: 2, Visits: 32

Thank you for the script, will be very useful.

Tony

Post #810683

Sean Smith-776614

Posted Thursday, October 29, 2009 6:25 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 90, Visits: 369

My pleasure. Hope it helps!

Post #810687

SVonTilbon

Posted Thursday, October 29, 2009 6:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 8:58 AM
Points: 5, Visits: 27

I'm getting syntax errors in SQL 2008 in the Northwind D-Base beginning with this line...:
WITH cte_date_base_table AS

Also it doesn't recognize ROW_NUMBER as a function name.

Help!

SVonTilbon

Post #810697

Sean Smith-776614

Posted Thursday, October 29, 2009 6:45 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 90, Visits: 369

It was developed on SQL Server 2005, though it should work on 2008. Have you tried running it on a different database? Also, sometimes when you copy scripts from SQLServerCentral.com it also copies "funky" (and sometimes "invisible") characters with the code. It's happened to me and I've needed to reformat the code before it would run. Hope this helps.

Isn't Northwind SQL 2000? You need at least 2005 for the code to work as ROW_NUMBER is not recognized in 2000 nor is CTE.

Post #810706

Nice Marmot

Posted Thursday, October 29, 2009 10:54 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 09, 2013 7:52 AM
Points: 392, Visits: 619

Nice-looking date dimension table. Smile

Post #810999

Sean Smith-776614

Posted Thursday, October 29, 2009 11:02 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 90, Visits: 369

Thanks! Dates can be a REAL pain to work with sometimes, so I figured that this could help a lot of people.

Post #811010

lukas-311170

Posted Thursday, October 29, 2009 6:16 PM

Valued Member

Group: General Forum Members
Last Login: Monday, December 10, 2012 12:11 PM
Points: 66, Visits: 101

@svontilbon: works fine in sqlserver 2008 express

Post #811308

lukas-311170

Posted Thursday, October 29, 2009 6:35 PM

Valued Member

Group: General Forum Members
Last Login: Monday, December 10, 2012 12:11 PM
Points: 66, Visits: 101

Thank you for sharing this, dates are kind of "fun" (or a pain). Now the script only lacks a parameter to set the first day in the week to Monday (= the case in Europe) and to add a column isoweek (isoweek 1= first week with at least 4 days in it I guess) - for example 1 January 2010 is in week 53 of the year 2009 ! so isoweek 200953 or something like that.

Guess that is work for somebody else ! Wink

Post #811312

Sean Smith-776614

Posted Friday, October 30, 2009 6:29 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 90, Visits: 369

I'll put it on the to do list. :) Great idea. As for the first day of the week, it should change automatically to whatever your SQL Server instance settings are. So if day 1 is Monday rather than Sunday, the code should compensate for this. Hope that helps.

Post #811505

« Prev Topic | Next Topic »

41 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions