karthik M (11/19/2012)

---

I tried for 6 numbers with the below query.

select col1, col2, col3, col4, col5, Col6

,(s1+abs(s1)+s2+abs(s2)+s3+abs(s3)+s4+abs(s4)+s5+abs(s5)+ s6+abs(s6))/2 as Positive

...

dwain.c (11/19/2012)

---

Eugene Elutin (11/19/2012)

---

I think you meant to...

CELKO (11/19/2012)

---

Sorry to disappointing you again, but it really can!

Have you tried it? If you need our...

That is real delight! How cool it is! There is only one...

kramaswamy (11/19/2012)

---

Hm - I'm actually kinda surprised that works. I would have thought it would fail because the WHERE condition would evaluate AS

@TableB_ID IS NULL (TRUE) OR TableB_ID (Value OR...

kramaswamy (11/19/2012)

---

Yeah - I've used the Dynamic SQL approach before, and it does work pretty well, but I'm not a huge fan of it. Never knew about the RECOMPILE option...

Actually, I found even more elegant way:

SELECT *

FROM tablename

...

Have you tested it? You should try:

CREATE TABLE [dbo].[MyTable](

[col1] [int] NOT NULL,

[col2] [int] NOT NULL,

[col3] [int] NOT...

Before using one or another technique, you should read this article from one of the best experts in this area:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

There is another, more mathematical way:

If no zero values in your columns:

select *, 5-Positives as Negatives

from (select *,(sign(col1)+sign(col2)+sign(col3)+sign(col4)+sign(col5)+5)/2 Positives

from tablename) sn

And, if there are zero values:

select...

eranzo111 (11/19/2012)

---

A dead end I guess... 🙁

I was so happy when I saw the significant performence improvement when I used the full text search instead of the LIKE query,...

Jeff Moden (11/19/2012)

---

...

To answer the rest, the only way to know for sure is to run a test or two. If someone would create a CLR to drop characters...

Ough, YES! And there is...

John Mitchell-245523 (11/19/2012)

---

If the WHERE clause includes a condition on the outer table, as your example does, then yes, the outer join is turned into an inner join. Try...

No it does not. It does really depend on what you put...