| Author |
 Topic  |
|
|
aswindba1
Starting Member
USA
40 Posts |
 Posted - 01/23/2013 : 16:55:47
|
Can Any one help me with belwo query.
UPDATE T1
SET T1.[Count] = 1.00/(SELECT COUNT(*) FROM [Tracker] T2 WHERE T1.[Application ID] = T2.[Application ID])
FROM [Tracker] T1
Actually in [Application ID] we ave some null values and getting the follwing error. Could you Please modify the query.
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
The statement has been terminated. |
|
|
jimf
Flowing Fount of Yak Knowledge
USA
2868 Posts |
Posted - 01/23/2013 : 17:37:05
|
UPDATE T1
SET T1.[Count] = 1.00/ NULLIF ((SELECT COUNT(*) FROM [Tracker] T2 WHERE T1.[Application ID] = T2.[Application ID]),0)
FROM [Tracker] T1
Jim
Everyday I learn something that somebody else already knew |
 |
|
|
bitsmed
Posting Yak Master
Denmark
107 Posts |
Posted - 01/23/2013 : 17:40:55
|
quote:
Originally posted by jimf
UPDATE T1
SET T1.[Count] = 1.00/ NULLIF ((SELECT COUNT(*) FROM [Tracker] T2 WHERE T1.[Application ID] = T2.[Application ID]),0)
FROM [Tracker] T1
Jim
Everyday I learn something that somebody else already knew
Of course Jim meant:
UPDATE T1
SET T1.[Count] = 1.00/ NULLIF ((SELECT COUNT(*) FROM [Tracker] T2 WHERE T1.[Application ID] = T2.[Application ID]),1)
FROM [Tracker] T1
|
|
|
|
jimf
Flowing Fount of Yak Knowledge
USA
2868 Posts |
Posted - 01/23/2013 : 17:46:30
|
No I didn't. NULLIF says if the 1st value = the 2nd value, return NULL. It's different than an isnull statement. Mine says "if the divisor = 0, return null instead"
Jim
Everyday I learn something that somebody else already knew |
|
|
|
bitsmed
Posting Yak Master
Denmark
107 Posts |
Posted - 01/23/2013 : 18:06:30
|
quote:
Originally posted by jimf
No I didn't. NULLIF says if the 1st value = the 2nd value, return NULL. It's different than an isnull statement. Mine says "if the divisor = 0, return null instead"
Jim
Everyday I learn something that somebody else already knew
My mistake - sorry. |
|
|
| |
Topic |
|
Query Help
