The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
Guest
Ak rsi1
By Guest on 14th March 2019 11:50:09 AM | Syntax: TEXT | Views: 3



New paste | Download | Show/Hide line no. | Copy text to clipboard
  1. SELECT 100 * cp.cpodr_bno / le.lesiz
  2.   FROM sys.x_kcccp cp,
  3.        sys.x_kccle le
  4.  WHERE le.leseq = CP.cpodr_seq
  5.    AND bitand (le.leflg, 24) = 8;
  6.    
  7. -- OR
  8.  
  9. SELECT ROUND((cpodr_bno / lesiz), 2) * 100
  10.   FROM sys.x_kcccp a,
  11.        sys.x_kccle b
  12.  WHERE a.cpodr_seq = leseq;



  • Recent Pastes