Viewing 15 posts - 10,486 through 10,500 (of 18,923 total)
Can we see the code of the procedure and how it is called?
December 22, 2006 at 9:44 am
So you still have a question or you're all right?
December 22, 2006 at 9:11 am
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...
December 22, 2006 at 9:10 am
Just a hunch : maybe you could set up a job that runs each day at midnight and do the updates you need??
December 22, 2006 at 8:00 am
So may I ask what is the point of using that operator at all?
December 22, 2006 at 7:34 am
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.
December 21, 2006 at 3:09 pm
Don't have much better to offer but you should be good to go :
December 21, 2006 at 2:37 pm
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...
December 21, 2006 at 11:21 am
Not that much more complicated... but it may very well seem so if it's the first time you meet this code
.
December 21, 2006 at 9:26 am
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...
December 21, 2006 at 9:25 am
Always remember this... between you and the server, only the server has the need to be lazy
.
December 21, 2006 at 8:41 am
Viewing 15 posts - 10,486 through 10,500 (of 18,923 total)