SHARE
TWEET

Untitled

a guest Feb 16th, 2020 251 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  update AnalysisLookup
  2. set isactive =0,
  3. Comments='same as id 93'
  4. where original in (select   original
  5. FROM AnalysisLookup
  6. where original = 'monomeric SiO2')
  7.  
  8.  
  9.  
  10.  UPDATE
  11.   M
  12. SET
  13.   M.AnalysisLookupID = LTRIM(RTRIM(replace(comments ,'same as id ', '')))
  14. FROM
  15.   [GroupsDetail] AS M
  16. INNER JOIN
  17.   AnalysisLookup L
  18. ON
  19.   M.[AnalysisLookupID] = L.[AnalysisLookupID]
  20.    where M.AnalysisLookupid  in (select AnalysisLookupid from    AnalysisLookup
  21.                                  where isActive = 0   and comments ='same as id 93')
  22.  
  23. GO
  24.  
  25. UPDATE
  26.   M
  27. SET
  28.   M.AnalysisLookupID = LTRIM(RTRIM(replace(comments ,'same as id ', '')))
  29. FROM
  30.   AnalysesAdditionalLookupDetail AS M
  31. INNER JOIN
  32.   AnalysisLookup L
  33. ON
  34.   M.[AnalysisLookupID] = L.[AnalysisLookupID]
  35.    where M.AnalysisLookupid  in (select AnalysisLookupid from    AnalysisLookup
  36.                                  where isActive = 0   and comments ='same as id 93')
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top