CODEWITHSUNDEEP
sql-server-2008
Roy
Roy

Reputation: 2323

Add data field to existing table with LIVE DATA

I'm working on a project which generate report every quarter. So there is a table supporting this:

Report: ID(int) Quarter(byte)

...

But later, the requirement changed and need the system to support more then one report in the quarter like this: 2-1, 3-2, ...

How can I support this requirement change? Thanks in advance!

Upvotes: 0

Views: 150

Answers (3)

Roy
Roy

Reputation: 2323

The solution I'm going to use it to change the Quater to be a foreign key, point to another table, so I can easily deal with the database with LIVE DATA. or use 2 many to many table and record extra field there. What's your opinion? Thanks!

Upvotes: 0

Mark Redman
Mark Redman

Reputation: 24515

How about:

Report: ID(int) Quarter(byte) Date(DateTime)

Upvotes: 1

Johannes Rudolph
Johannes Rudolph

Reputation: 35731

not sure why you use byte for quarter and dont have a year column. Byte holds 256 different values, enough for four quarters, okay.

I'd do the following: Year(int) Quarter(byte if you wish) ReportNumber(int)

Upvotes: 0

Related Questions