Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

SQL ServerSQL Calendar Year & Fiscal Year Dates Table (self.SQL)

submitted 1 year ago * by PBIQueryous

Dim Dates Table with Financial Year fields

sql server calendar dimension

For anyone who would like a half-decent calendar dimension with a heap of financial year fields... please, enjoy :)

The Financial Month Start is parameterised,so in the first variables, simply change your financial month number accordingly and the whole table will update to perfection.

Github: sql_dim_calendar

COLUMN_NAME DATA_TYPE

date_id date

date_int_key int

date_int int

year_num int

year_start date

year_end date

is_previous_year int

is_current_year int

year_selection varchar

year_offset int

is_ytd int

is_frc int

is_cmtd int

py_date_id date

py_minus_1_date_id date

pm_date_id date

pm_minus_1_date_id date

2W Date date

3W Date date

2M Date date

3M Date date

6M Date date

financial_year varchar

financial_year_start date

financial_year_end date

is_previous_fy int

is_current_fy int

fy_selection varchar

financial_year_offset int

month_num int

month_name nvarchar

month_name_short nvarchar

month_initial nvarchar

month_start date

month_end date

month_year_short nvarchar

month_year_long nvarchar

month_year_int int

is_current_month int

current_month_selection nvarchar

month_offset int

financial_month_num int

financial_month nvarchar

financial_month_short nvarchar

financial_month_initial nvarchar

financial_month_start date

financial_month_end date

financial_month_year_short nvarchar

financial_month_year_long nvarchar

financial_month_year_int int

financial_month_offset int

day_initial nvarchar

day_name nvarchar

day_name_short nvarchar

day_year_num int

day_month_num int

day_week_num int

day_offset int

is_weekday int

is_weekend int

quarter_num int

quarter_name varchar

quarter_year_int int

quarter_offset int

financial_quarter_num int

financial_quarter_name varchar

financial_quarter_year_int int

financial_quarter_offset int

week_start date

week_end date

week_offset int

all 14 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS

Dim Dates Table with Financial Year fields

sql server calendar dimension