twin.devil (3/4/2014)

---

its failing on the join condition .... your other table have a data type of float.

you with ensure that data on which you are joining should be of numeric...

Above bolded parts in the quotes display a contradiction. Did the query run correct when removing both the CASE statements or did it NOT run correct?

If it didn't run correct...

GilaMonster (3/4/2014)

---

Then there's something going on that you're not telling us about, because there are no floats around in case statements I wrote for you and if the columns are...

Yea but I get the same float error 🙁

igloo21 (3/4/2014)

---

HanShi (3/4/2014)

---

What is the defined datatype for column [sCustomer_number] in table [dbo].[abc_Customers] ?

I expect the error is caused by the CASE statement. Can you confirm this by removing both...

ChrisM@Work (3/4/2014)

---

SELECT DISTINCT TOP (100) PERCENT

c.iCustomer_id,

c.sCustomer_number AS CustomerNo,

CASE WHEN c.sCustomer_number = 'SL000000' THEN 660 ELSE c.sCustomer_number END AS sCustomer_number,

c.sCustomer_name AS CustomerName,

c.sCustomer_state AS Customerstate,

cc.CustomerType AS...

HanShi (3/4/2014)

---

What is the defined datatype for column [sCustomer_number] in table [dbo].[abc_Customers] ?

I expect the error is caused by the CASE statement. Can you confirm this by removing both the...

Thanks for the reply, yes it goes away, but I need this...

Keith Tate (1/10/2014)

---

Can you join Productss (is it really spelled with two S's :hehe:)

Actually no it's not spelled with two s's I did some code scrubbing before posting it and...

davidandrews13 (1/10/2014)

---

i'm presuming that the code in your EXISTS statement always brings back at least one row?

it looks like, because it always brings back data, the EXISTS statement will always...

This worked wonderfully! The only thing I had to chenge was switching it from less than to greater than. A big thanks for your assistance!

Thanks Sean. I am adding the column as "AS ImportDate". This is actually a stored proc that I am putting together that will import into an xls. The trouble that...

delete

So basically I'm wanting to do something like this:

CASE WHEN ImportDays=(Select DATEADD (day,-30,getdate()))THEN 'NEW' ELSE 'Older than 30 days' END AS ImportDate

quote]

I can assure you that sql did not ignore your case expression. Did you try adding the case as a column in your select? What is returned in that column?...