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'?

Did you try it? Does it work?

Look at the "="...what is it doing in the middle of this?

You have two major problems with this type of design.

1) This appears to wide open to sql injection. NEVER NEVER NEVER execute anything that the user has the ability...