Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Need to understand how queries and this sample query is processed. RE: Need to understand how queries and this sample query is processed.

  • July 24, 2014 at 5:54 pm

    #1732222

    It doesn't seem to update the results the right way, at least from my understanding..

    I get results as

    pidnamesales

    1gary 100 --instead of 230

    2sam 90 -- instead of 130

    Did I understand this correctly? Or what is it that the query is trying to do?

    ----------------------------------------------------