capn.hector (4/27/2012)

---

ColdCoffee (4/27/2012)

---

Sean Lange (4/27/2012)

---

ColdCoffee (4/27/2012)

---

Sean Lange (4/27/2012)

---

Keep in mind that none of us (or at least most of us) did not get the opportunity to see your now retracted...

Sean Lange (4/27/2012)

---

ColdCoffee (4/27/2012)

---

Sean Lange (4/27/2012)

---

Keep in mind that none of us (or at least most of us) did not get the opportunity to see your now retracted comment. Perhaps...

Sean Lange (4/27/2012)

---

Keep in mind that none of us (or at least most of us) did not get the opportunity to see your now retracted comment. Perhaps the guilt of...

Lynn Pettis (4/27/2012)

---

I...

He? the names sounds like a SHE :-D. Whats your take ?

{Lets, for fun, hijack this thread :-P}

Lynn Pettis (4/27/2012)

---

ColdCoffee (4/27/2012)

---

I guess the OP wants to know why NULL cannot be used with = operator but can be used with the keyword IS

Riya_dave, it depends on this...

I guess the OP wants to know why NULL cannot be used with = operator but can be used with the keyword IS

Riya_dave, it depends on SET ANSI_NULL setting...

What i see from the CASE statemnet is that, based of the payment_id value, he is choosing from 2 different tables.. If thats the case, then i dont think there...

First, you missed providing the data in readily consumable format.

Second, you missed showing us your subqeury query.

Third a JOIN is in order...

Polka, as others have already noted, you query is performing exactly what u r asking it to

"Get me the list of values from Validate tables that do not have 23...

select partnumber, count(distinct partdesc)

from parttable

group by partnumber

having count(distinct partdesc) > 1

130 and 131 should be using NVARCHAR as they may produce Hijri script

Like this:

Select 130, Convert(NVarchar(50),GetDate(),130) Union All

Select 131, Convert(NVarchar(50),GetDate(),131)

You would better off be writing it in IF...ELSE block. THat would produce a decent plan always.

But if u insist in using single query to do that, then u can...

Try this 🙂

declare @string table ( string varchar(200) )

insert @string

select '\Beverages\Soda Pop\Mountain Dew'

union select '\Beverages'

union select '\\Food'

select s.string , crsapp.Idx

...

Can you just show us some sample data?