Yep, I agree... triggers will normally do the trick.  My only concern with triggers would be that folks with DBO, SA, DDL Admin, and (I think) Bulk Insert Admin privs...

Hi Lowell,

Heh... Not to worry, Lowell... as always, your response shows the good person you are.

The give away is normally a question laid out so well that if the person...

If it's a once per month report as you say, Craig, then a view offers no particular advantage because the underlying data will have changed enough to force a "recompile"...

Lowell covered that... you just need to modify the numbers in the "row 5 through row 12" example you asked for and he gave.  If you are using SQL Server...

Ah... got it... especially the part about developers thinking that data is stored in a physical order... thought you were just being obvious and that's not the case at all. Thanks...

You'll need to do a fair bit more reasearch, but this snippet from Books OnLine (found under "auditing", imagine that?) should help you get started...

C2 Auditing

C2 auditing is necessary...

Be careful using "Views of Views"... the outer view will frequently cause the inner view to fully materialize it's rows especially when aggragates are used in the outer view... it...

And... he's learned nothing because none of you asked him to show what he tried on what is very likely to be a homework problem...

I believe adding the transaction increases the chances of a deadlock... better to let it wait than to form deadlocks.

??? I'm thinking that Lowell covered that pretty well...

How far back ya wanna go on the Month-x columns?

Heh... yeah... I remember that discussion... It's a bloody shame that Microsoft keeps changing features to bugs especially on things like this... no wonder lot's of folks are hesitant to...

Well... hats off to MS... ALL of our servers had the MS patch and all switched time correctly at the appointed time.  Even my home machine updated correctly and on...

Peter,

Ol' friend, thanks for the feedback.  I haven't been "blessed" with 2k5 yet, so I always wonder how these things work out there.

Yes, you're correct.  Randy originally said that this...

Randy and Ken,

Yeah, it's pretty much an addiction to me.   Thanks for the feedback... it's part of the addiction