Advice needed for modeling the financial year.

The solution is the use of the user-define data type;
Ex: you can create a user-define data type by using:

DECLARE financialYear

(@ValueID nvarchar(15), @KPIID

nvarchar(15), @Budget nvarchar(15), @Actual

nvarchar(15), @Stretch nvarchar(15), @Date

datetime (15) )

CONSTRAINT CheckfinancialYear CHECK (financialYear LIKE '[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]' )

The above code defines some values of the UDT with some

constraints(additional to your requirements).

And the accessing/create part as below:

CREATE TABLE YEARBUDJET
( fYear as financialYear,
......
.......
.....)

SELECT financialYear
FROM YEARBUDJET fy
WHERE fy.KPIID = ‘1’
AND fy.Date = SYSDATE

I think this will satisfy your requirements.

SupunLiyanage at 2007-8-31 >