SHARE
TWEET

Untitled

a guest Apr 19th, 2019 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Automated (naive approach)
  2. SELECT DISTINCT
  3. source_string,
  4. CONCAT('"', concept_code, '"') AS source_code,
  5. concept_name AS source_name,
  6. "String" AS input_type,
  7. domain_id AS source_domain,
  8. vocabulary_id AS source_vocabulary
  9.  
  10. FROM (SELECT DISTINCT
  11. c.concept_code,
  12. c.concept_name,
  13. c.domain_id,
  14. c.vocabulary_id,
  15. CASE
  16. {1}
  17. ELSE "NOT A MATCH TO SOURCE STRING" END AS source_string
  18. FROM {0}.concept c
  19. WHERE c.domain_id IN ({2}))
  20.                            
  21. WHERE source_string != "NOT A MATCH TO SOURCE STRING";
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