week range - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

week range

Author

Topic

skativarapu
Starting Member

13 Posts

Posted - 2006-07-06 : 14:37:59

i have a time dimension table with week number,datesm month....
i want to add a column which will display the week range
something like this

Date DateRange
------------------------------------------------------
2005-01-02 00:00:00.000 2005-01-02 / 2005-01-08
2005-01-03 00:00:00.000 2005-01-02 / 2005-01-08
2005-01-04 00:00:00.000 2005-01-02 / 2005-01-08
2005-01-05 00:00:00.000 2005-01-02 / 2005-01-08
2005-01-06 00:00:00.000 2005-01-02 / 2005-01-08
2005-01-07 00:00:00.000 2005-01-02 / 2005-01-08
2005-01-08 00:00:00.000 2005-01-02 / 2005-01-08

X002548
Not Just a Number

15586 Posts

Posted - 2006-07-06 : 14:46:43

I have no idea what you want to do.

Please read the hint link in my sig for instruction on how to post a question so you can get an answer quickly

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-07-06 : 14:48:59

You can use this date table function for that. It has what you want built into it.

Date Table Function F_TABLE_DATE
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

CODO ERGO SUM

skativarapu
Starting Member

13 Posts

Posted - 2006-07-07 : 11:56:39

HAY MIC, I ASKED FORO ONE HELP AND U GAVE ME A SOLUTION THAT WOULD SERVER THE REQUIRMENT THAT I AM GOING TO GET IN FUTURE
THIS PEACE OF CODE IS REALLY GOOD

THANK YOU VERYMUCH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources