Need math syntax :-)

[katbear]

Hi,

I need some SQL syntax to do the following:

Compare 2 integer values (from 2 different tables) and make sure that the values DO NOT DIFFER by more than 10%.

Not sure how to write this!

Thanks

 

[katbear]

What happens if you get a cheeseburger that is 10% smaller that advertised, but the manager is telling you that it's really only 9.090909% smaller?

Is this case for a refund?

 

[SQLDenis]

>>What happens if you get a cheeseburger that is 10% smaller that advertised, but the manager is telling you that it's really only 9.090909% smaller?

they post a warning that this is before cooking and the end result will be smaller b-coz of fluid loss

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions