Snapshot isolation?

Bingo.  And there are other solutions with other databases.

And, no, you are incorrect about the problem, which is stated quite clearly in the first sentence of the section...

• This reply was modified 5 years, 11 months ago by ZZartin.

ZZartin -

Getting a second page of data is not rerunning a query.  It's getting more data from a single query.  That is what is under discussion in...

ZZartin -

Getting a second page of data is not rerunning a query.  It's getting more data from a single query.  That is what is under discussion in this article...

Showing a user the results of a query based on the data in the database is the point of a database.  Re running any query against a volatile data set...

Right they won't see the 11th row because it's no longer the 11th row and displaying it as such is no longer accurate.  They will see that row if they...

Oh, what a recipe for disaster!  Since you are requerying the data every time, you have NO WAY to know if the offset is still valid.  You are going...

Also, as noted before, -1 has caused errors because of out-of-order date calcs.  To me, it's just not worth the potential issues.  Not to say you can't use it, of...

I think it's a circular argument.  You don't use it, because it's not familiar, but it's not familiar, because you don't use it.  I've been using the...

I think it's a circular argument.  You don't use it, because it's not familiar, but it's not familiar, because you don't use it.  I've been using the -1 variant...

Like others have said don't flat out say no especially when there are easy wins there for you like just looking at some execution plans for obvious weirdness.  Not only...

The standard pattern for getting the first day of the month is:

SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)

Stick to that pattern, don't corrupt it with -1 tricks!  That just makes...

In general I don't consider excel a suitable...

Stored procs are fine. Great way to exercise MORE control and avoid all the issues we've listed with joining and nesting views. I don't object to using stored procs....

This is good information.  My question now is, why even use a UDF as a source for a report?  Why not just have the report user access a view...

Correct. If they went' in and added new schema such as the one described above, would SSiS be able to detect that? Or, if they changed a stored procedure...