why not use this as it is and have a "balance" table, updated on a trigger every time a row is inserted into this table ?

On the trigger you'd do

if...

Visual Studio already has support for VSS built in ( VS 6 did too ).

Yukon will allow you to integrate code into the database, so I guess it will probably...

I think I know what you mean, you data looks something like this

EMP    RESP1    RESP2    RESP3    RESP4

AA     2        3        7        9

BB     5        8        1        4

so for AA you want...

Hi Jonathan,

We originally did use timestamp, but were led to believe that the data type was to be dropped from Yukon ?