So correct me if I am wrong but opinion is divided between "the answer is wrong" and "brilliant question learnt a lot!!". is there any real consensus on whether the...

Andy, very good question. However I would question the answer as regards the number of sub directories as the MSDN article quotes that restriction as Nesting Level restriction, not a...

Fully agree with Luis on this one, you need at least another table, but you do need to record history.

Think of questions like; does the allowance change annually, how...

Following on from Jeff Moden and his suggestion of sophistication, you should also consider whether the benefit is non-contributory, contributory or a loan.

If non-contributory is there a limit, is it...

I agree, the only viable option is to normalise, and why store rounded values; you have the value, use whatever report generator you use to round or format the...

Nice question shiva, thanks for the reminder 🙂

Curiously despite being allowed NULL, the last_access_time column has a default value of (sysdatetimeoffset()) 😉

I use a Filetable and despite what MS may say on the issue the table definition does appear to suggest that last_access_time can be NULL and is in fact (datetimeoffset(7),...