It appears you're looking to use horizontal partitioning.

You could do it by offset paging if each of the "sessions" requests a different page.  Is it possible for each request to query for a different page?  Otherwise, it...

Actually I have to waffle and say maybe it belongs in the employees table

Since it's a calculation based on the current state of the data couldn't you just use a query?  Why does the balance have to be stored? ...

.

.

Since it's a calculation based on the current state of the data couldn't you just use a query?  Why does the balance have to be stored?  Perhaps it...

.

Since it's a calculation based on the current state of the data couldn't you just use a query?  Why does the balance have to be stored?  Perhaps it could be...

Disclaimer: I'm not saying this is the correct way to do this.  But it's compact and nice to look at imo.  String integers convert implicitly and time differences are easily...

Mission accomplished.  It only took 4 days.

[Edit] I thought there was a typo in line 2 but the date difference seems to also need to include the day date.  Therefore, there's a typo in line 3...

• This reply was modified 5 years, 4 months ago by Steve Collins.
• This reply was modified 5 years, 4 months ago by Steve Collins. Reason: Combined dates and times by converting to datetime

What you posted is by definition not a table at all! The table must have a key. You cannot embed spaces in the data element name in any of...

There are different ways to accomplish this.  Here's one.  In order to use the ROW_NUMBER function in the OUTER APPLY I created a table valued function called dbo.func_reserve_accuracy_amount.  When OUTER...

• This reply was modified 5 years, 4 months ago by Steve Collins.

[Edit] Ok, there were 2 updates above and this post was after the first without having read the second.  So I'm wiping it out.  To be updated if possible

• This reply was modified 5 years, 5 months ago by Steve Collins.