Query Analyzer - Dividing Issue Help 1

[nerdalert1]

Hi all. Why in SQL 2K query analyzer when I run this:

SELECT 2000/8000 AS TEST

I am getting 0 back instead of 0.25?

 

[Pattycake245]

These are two integer values so the result will be a rounded integer. IE .25 will round down to 0.

If you did:

SELECT (2000*1.0)/8000 AS TEST

you would get your desired result

Tim

 

[nerdalert1]

Thanks Patty. Perfect thanks for the help on that.