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. Quote Link to comment 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 ?? ??? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.