Viewing 15 posts - 25,666 through 25,680 (of 26,487 total)
You will have to bite the bullet. If you do a search of this site, you will find several threads that discuss this very issue.
July 17, 2007 at 4:39 pm
This query would fail in SQL Server 2005 as well for the same reason it is failing in SQL Server 2000.
![]()
July 17, 2007 at 4:24 pm
Actually, try this:
WHERE (OrderProcessed = @CaseFlag) or (@CaseFlag = 2)
![]()
July 17, 2007 at 8:04 am
Try this:
SELECT * FROM Orders
WHERE (OrderProcessed = CASE @CaseFlag WHEN 0 THEN 0
WHEN 1 THEN 1
END)
or (@CaseFlag = 2)
![]()
July 17, 2007 at 8:02 am
Sergiy,
Its do bad your only arguments are attacks on other peoples education, experience, and beliefs. You would do better to provide specific facts and citiations to support your arguments rather than...
July 15, 2007 at 10:40 pm
Actually, I am quite aware of the great range of mathematics, but even advanced mathematics is based on elementary (not school) principles.
And Achilles will over take the tortoise; its physics,...
July 13, 2007 at 11:48 pm
Perhaps you should tell me if what they are saying at this link is true:
http://mathforum.org/dr.math/faq/faq.divideby0.html
July 13, 2007 at 10:43 pm
No, Achilles will over take the tortoise. But even then, you will never be wrong, right?
July 13, 2007 at 10:41 pm
And again you are wrong. n/0 = undefined, not infinity. But then again, I'm sorry, you are never wrong, are you?
July 13, 2007 at 10:23 pm
Wrong!
If 1/infinity = 0 then 1 = 0 * infinity which is wrong, as any grade school student will tell you that 0 * any number (0 * n )...
July 13, 2007 at 9:04 pm
Just one objection Sergiy, 1/infinity <> 0. It is extremely close, but isn't, so there is a possibility however slight that you can get a precise value.
July 13, 2007 at 7:46 pm
Okay, added the column names, same problem. As for draining the swamp, no. I am seeing how this could be applied to find all new and changed records that need...
July 13, 2007 at 2:48 pm
I am glad to here that things are running smoother and faster. I have setup a sandbox with the data you provided, but I haven't had a chance yet to...
July 13, 2007 at 9:54 am
Hadn't heard that one. Must have been before I joined the site.
![]()
July 12, 2007 at 6:09 pm
The first example I gave you fails even with an order by in the statement. Like I said, it appears to be a bit flaky and inconsistant. I have used...
July 12, 2007 at 6:08 pm
Viewing 15 posts - 25,666 through 25,680 (of 26,487 total)