Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Transact-SQL

financial year

how can you store a financial year in sql 2005

[54 byte] By [bobtheunknownfrommars] at [2007-12-25]
«« Creating Access-Table with DEFAULT value in Column
»» Not trivial MDX - help needed
# 1
wt do you mean by that? can u explain it further so that we can get the exact idea wt u wanna do?
Zadoras at 2007-9-3 > top of Msdn Tech,SQL Server,Transact-SQL...
# 2

What i ment is that when a person selects a date how do you set another column just to show the financial year....

EG:

column 1 = '09/09/2004'

column 2(financial Year) = '2005'

what i have done is that i have created a case satement that selects the correct date

THANKS

bobtheunknownfrommars at 2007-9-3 > top of Msdn Tech,SQL Server,Transact-SQL...
# 3

You can do it in a select statement:

SELECT tDate, CASE WHEN MONTH(tDate)>6 then YEAR(tDate)+1

ELSE YEAR(tDate) END AS FYear

FROM Dates

Or you can save the value in a new column such as a INT column through an update statement:

UPDATE Dates

SET fYear = CASE WHEN MONTH(tDate)>6 then YEAR(tDate)+1

ELSE YEAR(tDate) END

limno at 2007-9-3 > top of Msdn Tech,SQL Server,Transact-SQL...
# 4

I would absolutely suggest a calendar table like this for your translation needs. You calculate it once, store it away and then reference it. Here is an article (with code) I wrote on how to load a calendar table, including columns for fiscal_year and month:

A way to load a calendar table
http://drsql.spaces.live.com/blog/cns!80677FB08B3162E4!1349.entry

It also has several references to other articles.

LouisDavidson at 2007-9-3 > top of Msdn Tech,SQL Server,Transact-SQL...
SQL Server
Transact-SQL

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified