Divide By zero Error

Question

Hi i am trying to do the following calculation but I get an error satating 'divide by error encountered'

SELECT        Customer1, QtyRefunded, Year, Month, QtySales, CAST(SUM(QtyRefunded) * 1000000 / SUM(QtySales) AS DECIMAL(9, 2)) AS PPM
FROM            dbo.[Refunds&ShippedJoin]
GROUP BY Customer1, QtyRefunded, Year, Month, QtySales

I pressume it is becuase I am dividing a number by 0, however I don't know how to ressolve this error.
Thank you for your help in advance.

Answer 1

Simplay,You can follow this steps

1).Right click my computer->properies.
2).Advance->Startup and recovery->Click Settings.
3).Click edit it will display in notepad remove window 200 boot line and save->ok.

Answer 2

get it  Thanks both,
actually i want to remove window 2000 selection option during booting os.

Answer 3

First, go to Start Menu, right click on my computer, and choose properties.

Then, click on Advanced Settings.

Choose settings under Startup and Recovery.

And here we are. Click on the drop-down menu (highlighted in blue here) to select the default OS to be launched at startup.

Notice how you can set how long the boot-selection screen will stay up until it decides to load the default OS automatically. By default, it is set to 30 seconds, but mine are 10 secs.

if my answer helps you then check "Do you like this answer" check box please :)