You should read the article in my signature about splitting strings. It will blow this away for performance and it will explain how to use it.

Great question!!! Glad to see some of the more obscure stuff from 2012. Makes the research more challenging since there is not much coverage of this stuff. Keep them coming...

post withdrawn

If you need help with the sql for this you are going to have to provide ddl, sample data and desired output. Take a look at the first link in...

If your correct result set is found by running:

select system_id, name

from Validate

where system_id not in (23,24,25,26);

Then to find all the ones from the table that are not in that...

HUH????

post withdrawn

Lynn Pettis

Actually, what I was laughing at is the mixed terms for the boolean. True and No. I always thought it was True/False, or Yes/No, or 0/1...

It can work as a boolean but only for significantly large values of NULL. :w00t:

42

drew.allen (4/26/2012)

Sean Lange (4/26/2012)

Not sure what you mean by "It didn't like". 😛

I should be the same...

Not sure what you mean by "It didn't like". 😛

I should be the same as you did...

This is most likely do to precision differences between Oracle and SQL. Instead of the generic FLOAT type it is recommended you specify the scale and precision is both DBMS.

http://msdn.microsoft.com/en-us/library/ms151817%28v=sql.105%29.aspx

???

CustomerSales / TotalSales

And why are you adding a space and then replacing it with a '0'?