I don't have much time this evening but I do have a question...

WHY are people trying to TRUNCATE a table that the app or other people are trying to SELECT...

The developer whom I spoke to mentioned that...

Also, if you really are using RCSI, then using (NOLOCK) is a complete waste of code realestate.  Also, using (NOLOCK) by itself was deprecated years ago.  MS says...

@steve-2 Jones...

Have you taken a look at the "business end" of Sessionize?  I've not.  I've only been on the receiving end as a speaker but their write-up seems encouraging and...

It's...

You said in your narrative in your original post that "it reads last 30 mins of data from the tables involved" and yet ALL of...

You're probably not...

Admirable restraint there Jeff.  The temptation for "P-Sept" or "P7" must...

Just call it "P-cubed" or "P3" for "Proper Programming Practices" instead of all this Dev-this and Ops-that stuff.

Heh... I was having too much fun with this post and thought that someone might take it too negatively, and so I deleted it.

You should post your solution so that we can check it for you... a lot of people make a pretty bad error for things like this.

I'll also add that what looks to be the "3rd INSERT" is the only one that has non-sargable criteria in the Joins ...

    ...

You...

• This reply was modified 2 years, 3 months ago by Jeff Moden. Reason: Changed my mind

Based on your example this query uses the 'id' column to define the sort ordering of the running total.  Generally it's not a good practice to order by an...

It isn't the ASCII function that's causing your error:

Try these statements:

SELECT ASCII('.');
SELECT ASCII(NULL);
SELECT ASCII(42);

All of them return a valid value.

But these all cause the same error...