... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 17,899 of 19,505

Lutz Uhlmann to All

Re: Arithmetic overflow error converting

31 Aug 10 14:10:57

   035f47da   
   From: news@invalid.invalid   
      
   Am 31.08.2010 13:57, schrieb JJ297:   
   > I'm getting that on this stored procedure:   
   >   
   > it appears to be on this line:    N'CAST((1.0 * icnt / NULLIF(tcnt, 0)   
   > * 100) AS decimal   
   > (6,   
   > 1)) AS perc   
   >   
   > What do I change it to so I can get rid of the error?   
      
   Maybe tcnt is NULL so the term becomes icnt / 0 ???   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]