You're welcome, I'm happy I could help.

gissah (3/16/2011)

---

WHERE (Type NOT IN ('Siu-ai', 'Subrogation', 'Siu-fi', 'SIU', 'Siu-mi')) AND (Company = 'xxx') AND ([Compliant Status] = 'xxxxx') AND

...

One reason for using NoSQL is when there is no need to be careful about how safe the data is. NosSQL can be the "down and dirty," or "git...

Jeff Moden (3/11/2011)

---

There's no performance gain in it....

Also, you should rewrite the query to use an INNER JOIN rather than the older way its using more than one table.

I'm not sure you need the dynamic SQL there since your only variable is after the = sign in the query.

To answer your question, yes, you could use it later...

Ah, I should have caught that. Never mind.

Alvin Ramard (3/4/2011)

---

Speaking of WordPress, I think I may convert the Memphis PASS Chapter website to a WordPress site (my own host, not WordPress.com). Any WordPress users here have any...

Thank you for your answers, especially from two of you who are exceptionally knowledgeable, but I should have mentioned that this is on a warehouse which is not very often...

@mazz, that picture's hilarious - it must be a Border Collie. I have a Border Collie / Lab mix myself (in addition to a Husky). It's hard to...

vvignesh86 (3/3/2011)

---

Hi,

I have the same issue and when I try

=IIF(Fields!Column1.Value + Fields!Column2.Value = " ",TRUE,FALSE)

While previewing am getting

"The Hidden expression for the tablix 'Tablix1' contains an error: Input...

OK, the next time I submit a question, I'll be sure that the fluke answer, if there is one included, can in no way be misconstrued as a possible right...

You're welcome - glad I could help.

It looks like you may be trying to concatenate with the & sign, bit if so, you don't need the first [= " "]. I'm sort of guessing here,...

sknox (2/28/2011)

---

mtassin (2/28/2011)

---

I got this right but...

SELECT 0%0

gives

Msg 8134, Level 16, State 1, Line 1

Divide by zero error encountered.

So it seems you can use it to divide 0 by 0...