merck_delmoro Posted May 6, 2009 Share Posted May 6, 2009 update db_provisioning set [acct number] = b.[acct number], [cid type] = b.[cid type], [set-up date] = b.[set-up date], [termination date] = b.[termination date], [ixc provider] = b.[ixc provider], jurisdiction = [lata jurisdiction] from db_provisioning a, smfcid b where convert(float,a.ani) = b.[caller id] database records int a.ani: 8473641255 9086543468 4037465617 003602490B 012420755B 012454145B 012507387B ERROR: Server: Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to float. Link to comment https://forums.phpfreaks.com/topic/157140-can-you-help-me-to-solve-this-problem/ Share on other sites More sharing options...
dietkinnie Posted May 6, 2009 Share Posted May 6, 2009 Im not sure but it looks like the character "B" in ( 003602490B 012420755B 012454145B 012507387B ) Cannot be converted to Float as B is not a number ?? ??? Link to comment https://forums.phpfreaks.com/topic/157140-can-you-help-me-to-solve-this-problem/#findComment-828059 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.