SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 Date Table Function F_TABLE_DATE
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 5

ienneg
Starting Member

France
3 Posts

Posted - 11/21/2012 :  02:49:11  Show Profile  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

quote:
Originally posted by ienneg

Hi,
This is a great function and it helps a lot.
Now, that said, could you help add to it the ISO Quarter number?
Thanks



I am unaware of any actual definition or standard for "ISO Quarter number". Do you have a link to a standard or definition?

Function F_TABLE_DATE does have a column for the calendar quarter, QUARTER, where months 1-3 are Q1, 4-6 are Q2, 7-9 are Q3 and 10-12 are Q4. There ia also a YEAR_QUARTER column in format YYYYQ, Example = 20052



No I dont, I should have writen "ISO Quarter".
What I mean by that is the following:
When days end of december are part of folling year first ISO week, I am also looking at them being classified as Q1 of following year (same logic for Quarter than for ISO Week).

Thanks
Hope I am clear enough.
Thanks



CODO ERGO SUM
[/quote]

Edited by - ienneg on 11/21/2012 03:03:29
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 11/21/2012 :  17:11:52  Show Profile  Reply with Quote
quote:
Originally posted by ienneg

quote:
Originally posted by Michael Valentine Jones

quote:
Originally posted by ienneg

Hi,
This is a great function and it helps a lot.
Now, that said, could you help add to it the ISO Quarter number?
Thanks



I am unaware of any actual definition or standard for "ISO Quarter number". Do you have a link to a standard or definition?

Function F_TABLE_DATE does have a column for the calendar quarter, QUARTER, where months 1-3 are Q1, 4-6 are Q2, 7-9 are Q3 and 10-12 are Q4. There ia also a YEAR_QUARTER column in format YYYYQ, Example = 20052



No I dont, I should have writen "ISO Quarter".
What I mean by that is the following:
When days end of december are part of folling year first ISO week, I am also looking at them being classified as Q1 of following year (same logic for Quarter than for ISO Week).

Thanks
Hope I am clear enough.
Thanks


I really don't know what you are getting at.

In any case, unless there is an actual ISO Quarter standard, I would not want to add that to the function.

You are free to make any modification that you want to the function to support the needs of your organization.



CODO ERGO SUM
Go to Top of Page

ienneg
Starting Member

France
3 Posts

Posted - 11/22/2012 :  07:01:48  Show Profile  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

quote:
Originally posted by ienneg

quote:
Originally posted by Michael Valentine Jones

quote:
Originally posted by ienneg

Hi,
This is a great function and it helps a lot.
Now, that said, could you help add to it the ISO Quarter number?
Thanks



I am unaware of any actual definition or standard for "ISO Quarter number". Do you have a link to a standard or definition?

Function F_TABLE_DATE does have a column for the calendar quarter, QUARTER, where months 1-3 are Q1, 4-6 are Q2, 7-9 are Q3 and 10-12 are Q4. There ia also a YEAR_QUARTER column in format YYYYQ, Example = 20052



No I dont, I should have writen "ISO Quarter".
What I mean by that is the following:
When days end of december are part of folling year first ISO week, I am also looking at them being classified as Q1 of following year (same logic for Quarter than for ISO Week).

Thanks
Hope I am clear enough.
Thanks


I really don't know what you are getting at.

In any case, unless there is an actual ISO Quarter standard, I would not want to add that to the function.

You are free to make any modification that you want to the function to support the needs of your organization.




What I am getting at is the following:
My company calendar is different than the ISO one: the first week of the year is the week with at least 3 days (not 4 like in ISO).
And the Quarter are made of 5-4-4 Weeks of the calendar:
JAN = 5 weeks |
FEB = 4 weeks | =Q1
MAR = 4 weeks |

APR = 5 weeks |
MAY = 4 Weeks | =Q2
JUN = 4 Weeks |

etc...
As I am not as good as you do, I am trying to get help to create a similar function as yours which will do that.

Gilles


CODO ERGO SUM
[/quote]
Go to Top of Page

Kalaiselvan
Posting Yak Master

India
109 Posts

Posted - 01/23/2013 :  12:04:22  Show Profile  Reply with Quote
Hi,
Need a Table with single column From the following Input.

Start Date = 01 Jan 2011
End Date = 01 Dec 2012

TABLE FOR PERIOD=MONTHLY
[PERIOD]
JAN 2011
FEB 2011
MAR 2011
APR 2011
MAY 2011
JUN 2011
JUL 2011
AUG 2011
SEP 2011
OCT 2011
NOV 2011
DEC 2011
JAN 2012
FEB 2012
MAR 2012
APR 2012
MAY 2012
JUN 2012
JUL 2012
AUG 2012
SEP 2012
OCT 2012
NOV 2012
DEC 2012


TABLE FROM PERIOD=QUARTER
[PERIOD]
JAN 2011
APR 2011
JUL 2011
OCT 2011
JAN 2012
APR 2012
JUL 2012
OCT 2012


TABLE FROM PERIOD=HALF
[PERIOD]
JAN 2011
JUL 2011
JAN 2012
JUL 2012


TABLE FROM PERIOD=YEARLY
[PERIOD]
JAN 2011
JAN 2012


Depends on Period Chosen Need to Built the Single Column table. Help me to fix this Functionality.


Regards,
Kalai

Regards,
Kalai
Go to Top of Page
Page: of 5 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000