On 2/18/2015 2:36 PM, Jose I. Cabrera wrote: > these are my two steps: > 1. SELECT RateType FROM LSOpenJobs WHERE ProjID=132959 AND PSubClass='PM' AND > lang='DE-DE';
What is the point of this step? I don't see where and how the value you obtain therefrom is required for step 2. > 2. Use the RateType, let's say it's 10%, to create a this update > UPDATE LSOpenJobs SET ProjFund =... > WHERE > ProjID = 132959 AND lang = 'DE-DE' AND RateType = '10%' AND PSubClass = > 'PM'; If (ProjID=132959 AND PSubClass='PM' AND lang='DE-DE') condition was good enough to retrieve a unique RateType in step 1, then it should be good enough to identify a unique record to update in step 2. Why do you believe an extra condition of (RateType = '10%') is necessary? -- Igor Tandetnik
