Does anyone know why this query won't run? The fields fValue_xxx are all of the type 'nvarchar(50)'. It says that:
VB Code:
  1. Server: Msg 8114, Level 16, State 5, Line 1

  2. Error converting data type varchar to float.

on this query:

VB Code:
  1. UPDATE tBSC 

  2. SET fvalue_jan = '728,4',  

  3. fvalue_feb = '769',  

  4. fvalue_mrt = '912',  

  5. fvalue_apr = null,  

  6. fvalue_mei = null,  

  7. fvalue_jun = null,  

  8. fvalue_jul = null,  

  9. fvalue_aug = null,  

  10. fvalue_sep = null,  

  11. fvalue_okt = null,  

  12. fvalue_nov = null,  

  13. fvalue_dec = null  

  14. FROM tSBF_PI  WHERE lDepartmentID = 115 AND tSBF_PI.lPIID = 166 AND tSBF_PI.lSBF_PIID = tBSC.lSBF_PIID
When I remove the ',4' by fValue_jan, it works, otherwise it won't...

Anyone?