Needs query help on updating

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  April 14, 2015 at 12:44 pm

  #398326

  I have the following statement in my code.

  update #cases

  set

  total_time = datediff(MINUTE,start_dt_for_calculations, end_dt_for_calculations )

  I noticed after each run ( I mean if I run the script and in the next second run again ) the the following SQL Statement gives different output

  Select count(*) from #cases where total_time < 0

  Can anyone tell me what I am doing wrong with my output statement

• joshdbguy

  SSCertifiable

  Points: 7707

  More actions

  April 15, 2015 at 4:33 pm

  #1791227

  The temporary #cases table isn't updating while your other update is running correct?