SHARE
TWEET

Untitled

a guest Feb 16th, 2020 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT M.*,
  2.   M.AnalysisLookupID,  LTRIM(RTRIM(replace(comments ,'same as id ', '')))
  3. FROM
  4.   [GroupsDetail] AS M
  5. INNER JOIN
  6.   AnalysisLookup L
  7. ON
  8.   M.[AnalysisLookupID] = L.[AnalysisLookupID]
  9.      where M.AnalysisLookupid  in (17,93)
  10. GO
  11. SELECT  M.*,
  12.   M.AnalysisLookupID ,LTRIM(RTRIM(replace(comments ,'same as id ', '')))
  13. FROM
  14.   AnalysesAdditionalLookupDetail AS M
  15. INNER JOIN
  16.   AnalysisLookup L
  17. ON
  18.   M.[AnalysisLookupID] = L.[AnalysisLookupID]
  19.       where M.AnalysisLookupid  in (17,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