David,

You list a certain column (Seg or ID, ususally) in each of your tables as a Primary or Primary Key... are they actually Primary Keys with a PK constraint in place? ...

Thanks for the feedback, David... you've restored my faith... sorry for the misread.

You know the drill, Sree... "Show me the data".

The auto update statistics is off.

Luk... Sorry I missed that comment... Like I said... that's a form of...

Not a bad approach but have you tried it on, say, a million rows?  Makes a real busy server if you have 2000 connections trying to do the same thing...

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