March 14, 2011 at 12:10 pm
UPDATE
DWH_THE_ALLIANCE t1
INNER JOIN DWH_TDI_SOLUTIONTYPE tsol ON t1.SOLUTIONTYPE_LLAV_PR = tsol.SOLUTIONTYPE_LLAV_PR
INNER JOIN DWH_TDI_OPPORTUNITY topp ON t1.OPPORTUNITY_LLAV_PR = topp.OPPORTUNITY_LLAV_PR
SET
t1.SOLUTIONTYPE_LLAV_PR = 168
WHERE
topp.Status = 'WIN' AND
t1.TIME_LLAV_PR >= 20100701 AND
t1.SEBL_ID IN (
'CRMAP1-6-1DUXOPH'
) AND
t1.SOLUTIONTYPE_LLAV_PR = 155;
March 14, 2011 at 12:13 pm
UPDATE
DWH_THE_ALLIANCE
SET
DWH_THE_ALLIANCE.SOLUTIONTYPE_LLAV_PR = 168
FROM DWH_THE_ALLIANCE t1
INNER JOIN DWH_TDI_SOLUTIONTYPE tsol ON t1.SOLUTIONTYPE_LLAV_PR = tsol.SOLUTIONTYPE_LLAV_PR
INNER JOIN DWH_TDI_OPPORTUNITY topp ON t1.OPPORTUNITY_LLAV_PR = topp.OPPORTUNITY_LLAV_PR
WHERE
topp.Status = 'WIN' AND
t1.TIME_LLAV_PR >= 20100701 AND
t1.SEBL_ID IN (
'CRMAP1-6-1DUXOPH'
) AND
t1.SOLUTIONTYPE_LLAV_PR = 155;
March 14, 2011 at 12:18 pm
awesome thanks!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply