Thanks for the replies.  I don't want to use NOLOCK because I want to be sure that the feature is enabled before kicking off the job.  A customer might have...

• This reply was modified 3 years, 3 months ago by  John Deupree.

We want to implement a master location and make...

Thanks for the reply.

Co-worker gave me this code so it seems that your solution or either of these work. Only problem is that they don't check for valid objects...

Thanks for the reply.

Sorry this is for 2008R2. 🙁

That's new for 2012

Just curious. Why do you say it doesn't...

Very nice! It took me a while to get my head around using the row number functions to eliminate the consecutive 'same status' records.

Thanks for the reply.

andrewd.smith (4/30/2009)

Sorry about the confusion. Given the date range 1/1/2009 through 3/31/2009, how many days was each consumer active during that date range. Wayne's 'quirky update' technique above seems...

Thanks for the reply. Wow, what an interesting article and technique. I can see how that might have a lot of uses. I never thought about the...

Number of...

Thanks all for the replies.

It was an OLTP application. The DB was a bit unusual in that there were very few deletes. We (the DBAs) would...

Thanks for the reply. It's funny you would mention the application code handling it. That's exactly why I didn't add them in the first place. I had...

TOP limits the number of rows returned by your query. Assuming there are less than 1000 rows returned by the first query without the TOP,then adding the TOP 1000...

Thanks. I was thinking only of the recursive trigger setting which only controls triggers calling themselves. I wasn't aware that the nested trigger setting could control this. ...

I'll see if I can fo this. Thanks