My goal is to come up with questions

OK, it turns out that after meeting with the Development Team, this was a much more complex table design than originally needed. So, I don't need any of this,...

One issue you might run into when opening this JSON is some of the fields were given names which are SQL Server reserved words, for example 'Date' and 'Order'.  There...

• This reply was modified 5 years, 10 months ago by Steve Collins. Reason: Brackets also work to open JSON fields labeled with SQL Server reserve words

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, 10 months ago by Steve Collins.
• This reply was modified 5 years, 10 months ago by Steve Collins. Reason: Combined dates and times by converting to datetime