Jeff:

I've been thinking about the point of including Insert in the logging trigger.

What would you do in a circumstance where you find out that some employee has been altering records...

WOW!!!! I should have thought of that!!! That would be so much better!!!! :hehe:

Thanks Jeff.

On the use of Insert in the trigger, that gives me a date the data was first created, and by whom. I don't like having "CreatedDate" and "CreatedBy"...

In Catch statements, when I want to roll back, I usually use:

While @@trancount > 0

rollback

That gets rid of that error.

Separate ones will end up with better performance, usually. This is due to stored execution plans.

Without the relevant code, here are some general things to look for:

A) Is there a "Where" clause in the view that limits the rows it returns?

B) Are there columns in...

GilaMonster (3/20/2008)

---

GSquared (3/19/2008)

---

If you're using transactions to reduce the workload on the server, then yes, short transactions are good. If you're using transactions to control data integrity, sometimes you...

Yeah.

Of course, as in my prior example, turning "235 dogs, 5 cats", into "2355", is probably not a...

My next test has a major caveat on it: It won't work if there are two or more separate numbers in a field. For example, "123 dogs, 5 cats",...

Yeah, the scan count on Numbers is totally insane. I saw the same thing when I originally put it together. Looks like the regex is probably best for...

Sorry, didn't look far enough down on the list of results you provided....

Did you try the stacked CTEs script that I tested last, or just the inline functions?

Judging by the IO numbers, I'm going to assume you used the inline function that...

I never would have thought of doing the TypeID in the sub-tables as a calculated column. Tried it out, and you have to persist it to use it that...

If you're using transactions to reduce the workload...

A script I posted on another thread in this forum illustrates why I like the layout and readability of CTEs.

The thread is at http://www.sqlservercentral.com/Forums/Topic470379-338-1.aspx

The script is:

;with

CTE1 (ID, Position, Val)...