Guest User

Untitled

a guest
Nov 16th, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. Error converting data type varchar to numeric
  2.  
  3. SELECT IFS.Bin,CFL.CUSIP,IFS.[FROM],
  4. --IFS.Shares
  5. --SUM(isnull(cast(IFS.Shares as money),0))
  6. --CAST(isnull(IFS.Shares,0) AS VARCHAR(30))
  7. Shares =
  8. Convert(
  9. DECIMAL(18,5),
  10. CASE
  11. WHEN IFS.Shares LIKE '%[^0-9]%' THEN IFS.Shares --NULL
  12. ELSE IFS.Shares
  13. END)
  14. FROM
  15. mfclearing.ICE.ImportFileStaging IFS INNER JOIN
  16. mfclearing.Production.ClearingFundList CFL ON
  17. IFS.[From] = CFL.NasdaqSymbol
  18.  
  19. 521.92100000000005
  20. 9906.8510000000006
  21. 542.529
  22. 1043.8409999999999
  23. 3129.0839999999998
  24. 5285.4120000000003
  25. 104.367
  26. 126.98
  27. 332.02499999999998
  28. 530.12300000000005
  29. 575.57799999999997
  30. 895.56899999999996
  31. 1052.9349999999999
  32. 1167.0619999999999
  33. 1180.9939999999999
  34. 1630.8030000000001
  35. 247.232
  36. 2136.2040000000002
  37. 667.95500000000004
  38. 947.78599999999994
  39. 148.36000000000001
  40. 223.994
  41. 238.42699999999999
  42. 255.25700000000001
  43. 257.56999999999999
  44. 259.70600000000002
  45. 317.90199999999999
  46. 317.90199999999999
  47. 317.90199999999999
  48. 360.59199999999998
  49. 366.84399999999999
  50. 374.35000000000002
  51. 376.90199999999999
  52. 393.11500000000001
  53. 397.37200000000001
  54. 399.47699999999998
  55. 449.72699999999998
  56. 463.60899999999998
  57. 474.68599999999998
  58. 488.11599999999999
  59. 491.245
  60. 504.67399999999998
  61. 509.97899999999998
  62. 530.47199999999998
  63. 535.93299999999999
  64. 537.69799999999998
  65. 549.40599999999995
  66. 552.41700000000003
  67. 581.32600000000002
  68. 608.05100000000004
Add Comment
Please, Sign In to add comment