Budget Year design question - 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

SQL Server 2005 Forums

Transact-SQL (2005)

Budget Year design question

Author

Topic

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-12-10 : 11:15:29

hi there,

what would you say is the best approach to create a budget year table, that varies from customer to customer
I am thinking
Table : BudgetYear

	[budget_year_definitionID] [int] IDENTITY(1,1) NOT NULL,
	[budget_year_name] nvarchar(50) NOT NULL,
	[budget_year_from_month] int NOT NULL,
	[budget_year_to_month] int NOT NULL

but somehow I feel this is too simplistic, or maybe simple is best approach?

THanks

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-12-10 : 13:32:19

isnt it enough to have a generic calendar table and then store various schemes in another table having start and end months and then another one to link customer with schemes

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-12-10 : 13:50:57

Visakh16, thanks for response. I have a calendar table, which is a very new concept to the place I am working at and I am meeting stiff resistance. it is a place where they do not use primary keys and foreign keys, to give u an idea of the environment. Anyways got to move on. Your approach is perfect!

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources