I want to run a query that will insert rows into another table.
I also want to do some calculations on a couple of the columns:
SELECT
KEYCODESTRINGDESCRIPTION,
STRING,
Mailed,
Sales,
Orders,
CATALOGTITLE,
Response = Orders / Mailed,
[Average Invoice] = Sales / Orders,
SMP = (Sales / Mailed) * 1000
INTO TP_GA_REPORT
FROM TP_GA_REPORT_TEMP
I have a condition where some of the colums might have a 0 in them, which of course causes a "Divide by 0" error. What I would like to do is put an IF statement in the query to deal with this 0.
i.e.
if orders = 0 then response=0
else response = Response = Orders / Mailed
Hope this makes sense!
Thanks KenTry using SQL CASE:
SELECT ...,
CASE WHEN Mailed = 0 THEN 0 ELSE Orders / Mailed END,
...
FROM ...|||Thank you!!! So very much, worked like a charm!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment