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...

Thanks for all the replies.

The scripting option looks interesting. I will delve into it. In response to Grant, yes pulling from production cache is always an option if...

Steve,

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...

Steve,

I took a look at the SQL you posted and I am a bit confused as to what you are actually trying to accomplish. Do you have a small...