Home Forums SQL Server 2008 T-SQL (SS2K8) Need help on Update statment with where condition RE: Need help on Update statment with where condition

  • LutzM (8/23/2014)


    Unfortunately, you didn't answer my question:

    Why would idx=34 get a score of 10?

    It would be a lot easier if the data where in normalized form instead of a separated list. This makes the solution more complex than working with the apparently original data (JobNoticeCV.JobNoticeID]) ...

    Owh, that the mistake.

    idx=34 and ApplyJob=3 NOT EXISTS in r_ApplyJob. So, SCORE is maintained as 0.

    Sorry my bad.