| Null value maintenance [message #35610] |
Mon, 01 October 2001 06:19  |
kriser
Messages: 11
Registered: October 2001
|
Junior Member |
|
|
Does anyone have an efficient strategy for handling null values in a reporting database? The designer of the database wants to have zeros inserted into any column that does not have a transaction for a given month.
Example1 (New record is created in month 10 - Previous 9 months need to be updated with zeros)
Example2 (A record does not have a transaction for current month - Column needs to be updated with zero value.)
----------------------------------------------------------------------
|
|
|
|
| Re: Null value maintenance [message #35615 is a reply to message #35610] |
Mon, 01 October 2001 10:23  |
ASR
Messages: 1
Registered: October 2001
|
Junior Member |
|
|
I think writng trigger should resolve your problem.
Thanks,
Aluri
----------------------------------------------------------------------
|
|
|
|
| Re: Null value maintenance [message #35623 is a reply to message #35610] |
Tue, 02 October 2001 04:47 |
jim
Messages: 74
Registered: July 2000
|
Member |
|
|
I would look at modifying the table to set the columns as not null with defaults of zero.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
