Data type conversion error

• saravanatn

  SSCarpal Tunnel

  Points: 4533

  More actions

  August 16, 2017 at 1:01 am

  #324969

  I am doing data comparison between Source table and Target table . I used source MINUS target using EXCEPT query .But it is returning values for Member_id =2 and Member_id =4.As the value is same I would like this query to return zero records.So I tried Cast,Convert and Round but no luck. Any possible solution for this scenarios.

  Source Table:
  Member_id  checkup code
  1                     E22.2
  2                     1
  3                     F24.222 
  4                     2
  Target Table:
  Member_id  checkup code
  1                     E22.2
  2                     1.0000
  3                     F24.222 
  4                     2.0000

  Thanks in advance...

  Saravanan

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 16, 2017 at 1:03 am

  #1955394

  Can you post the definitions of the two tables and the query that you're using please?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass