SHARE
TWEET

Untitled

a guest Jul 16th, 2019 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Select col1,'EOI' as col4,col2  from (
  2. Select 'EOI' as col1,count(drmca_epcsubcontdtls_fk) as col2 from drmaincontanalytics_tbl where drmca_l1evnttype=1
  3. union
  4. select 'EOI' as col1,count( drsubcontanalytics_pk) as col2 from drsubcontanalytics_tbl where drsca_l2evnttyp=1
  5. )
  6.      
  7. MEOI_TENDSTATUS =
  8. VAR X1 =
  9. CALCULATE (
  10.     DISTINCTCOUNT ( drmaincontanalytics_tbl[drmca_epcsubcontdtls_fk] ),
  11.     drmaincontanalytics_tbl[drmca_l1evnttype] = 1,
  12.     drmaincontanalytics_tbl[drmca_tendstatus] = 5
  13. )
  14. VAR X2 =
  15. CALCULATE (
  16.     DISTINCTCOUNT ( drsubcontanalytics_tbl[drsca_epcsubcontdtls_fk] ),
  17.     drsubcontanalytics_tbl[drsca_l2evnttyp] = 1,
  18.     drsubcontanalytics_tbl[drsca_tendstatus] = 5
  19. )
  20. RETURN
  21. X1 + X2
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