Can we see the code of the procedure and how it is called?

So you still have a question or you're all right?

I do, that's why I ask the question.  I read the books online section for unary operator and that doesn't clear it up much.

I'm sure there must be a valid...

Just a hunch :  maybe you could set up a job that runs each day at midnight and do the updates you need??

So may I ask what is the point of using that operator at all?

HTH.

Search these forums for parameter sniffing.  You'll find plenty of information on the reasons and workarounds.  Post back if you have any further questions.

Don't have much better to offer but you should be good to go :

http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=sql%20server%202000%20sp4&DisplayLang=en

k, good luck with that.

Happy holidays .

What table is that? sysindexes?!

SELECT DISTINCT Attribute1, CASE WHEN Col2 > Col1 THEN Col1 ELSE Col2 END AS Col1, CASE WHEN Col2 > Col1 THEN Col2 ELSE Col1 END AS Col2, Keys FROM dbo.YourTable

That'll...

Not that much more complicated... but it may very well seem so if it's the first time you meet this code .

I've been following it.  I just had nothing else to add.  Regex is the only [simple] solution for this problem and it is far from my area of expertise so I...

What was the other answer?

Always remember this... between you and the server, only the server has the need to be lazy .