Conditional split fails with numeric data

• NIRANJANA1977

  SSC Eights!

  Points: 854

  More actions

  April 6, 2009 at 11:09 am

  #130360

  Hi all

  I am facing very strange problem with conditional split. When I compare two numeric fields I could not get results accordingly.

  eg. S_fact_value != LKP_S_FACT_VALUE with value 90.00 & 100.00 respt . I don't see record count increased for updated rows .

  What could be the problem

  Both the fields have same data type numeric(18,2)

  Help

• Carolyn Richardson

  SSCrazy Eights

  Points: 8357

  More actions

  April 7, 2009 at 4:59 am

  #973215

  Can you show a screen print of the Conditional Split Transformation Editor for us to see what you are actually using to split the data?

  Facts are stubborn things, but statistics are more pliable - Mark Twain
  Carolyn
  SQLServerSpecialists[/url]