Thanks for this series. I have most of this logic and more in views which I use interactively as well as from a python script to generate a spreadsheet of...
We use a structure that contains all the sql server error variable values. We add to that several columns which are related to the who, what, when and where of...
Our methodology depends on the size of the set of data. For something relatively small we select the set of data and validate it is what we want. We convert...
It is not only transactions that may happen while your are processing, your insert table may have multiple rows depending on the scope the transaction. This is one of the...