SQLTeam.com | Weblogs | Forums

An invalid floating point operation occurred

Hi,

I'm getting the following MS SQL error 'Msg 3623, Level 16, State 1, Line 636
An invalid floating point operation occurred.'

I'm running the following update statement (this has previously worked on a different periods dataset):

update #OPF_BUILD
set TOTAL_CAP = LGD * dbo.GET_NORMSDIST((dbo.GET_NORMINVDIST(PD)/SQRT(1 - FINAL_R) )+(SQRT(FINAL_R/(1 - FINAL_R))*dbo.GET_NORMINVDIST(0.999)))
where PD_CHECK not in ('NO_PD')

Can anyone help me navigate this please?

please check the data type of the column being updated !!!!!!

example
set column1 = abc+def

data type of column1
and
data type of result of abc+def

should match !!!!!!