On 2/18/2015 3:59 PM, Igor Tandetnik wrote: > 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. I need to know what the percentage for this specific project ID, 132959, and language is going to be calculated. This may be different depending on the project. So, it may be 3%, 5%, 10%, 20%, 25%, etc. That is my problem, I don't know how to grab that without this step.
> >> 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? I have to change the 20% to .20 to create the UPDATE. Correct?
