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

  • August 23, 2014 at 9:22 am

    #1740470

    What are you trying to do?

    Your description is rather vague...

    For instance, what do you mean by

    Where idx=34, Numeric in ApplyJob (3) EXIST in r_ApplyJob --> SET score=10

    ??

    For that idx value there's no '3' in r_ApplyJob. Why change the core?

    Why do you store numeric values as a list in a single column?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]