Where can I find that tumbleweed emoticon?

Anyone? no ideas? :ermm:

I have a funny feeling that the problem is that it is not possible to work out the percentage value of a value based on both the column group and...

Thanks for the response Kyle

One thing I ommitted to mentioning in my intial post was the version that we are currently running:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)...

Oh well - this one has not raised it's ugly head since....and the other deadlocks I have managed to work out the resolution....so all's well that ends well I suppose...fingers...

Hello - thanks for the response. Yes it certainly is a U lock type - I will see if I can capture it...the deadlock isn't happening all the time, so...

Okay - well thanks for the confirmation and for helping set my mind at ease....was sort of perplexed to say the least.

Thanks again

well after making it a table level trigger, everything is working fine now. I have removed the SQL Agent Job and the world is nice and calm and returning expected...

yeah it's pretty weird though huh!?! I might dump the concept into a trigger instead and see if that suffers from the same problem....

although then I wonder because I am...

Well yes and no.

The code is working up until the point after it first raises the error; for every run of the code thereafter it creates the error again...

I don't want the job to fail though - I only want the error to be logged so that the alert can pick it up - which it does fine....

The SQL agent raises the error

There is a SQL alert setup, that notifies the operator

The issue is certainly to do with the SQL Job (rather than the alert) because I...

Hi Neal, thanks for the response.

I am all for simplification so have put that suggestion in place (using >= rather than BETWEEN), but alas no difference.

And yes I always...

thats awesome! I was trying to do recursion with the cte but my brain was just not kicking in and sorting it out for me. Thanks for that. This will...

Thanks Jeff for your response; I have tried this but to no avail.

Additionally I have removed the host file from the equation, so while logged onto the box as...