Guest User

Untitled

a guest
Jan 21st, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. String countPersonQuery = "select count(s.SUKANG_ID) as person, COUNT(case when s.SURYO_YN='Y' then s.SURYO_YN end) as suryo, count(distinct o.title) as title, count(distinct m.company_name) as company from tryler..TOpenKwamok as o"
  2. + " inner join tryler..TSukang as s on s.OPEN_ID = o.OPEN_ID"
  3. + " inner join tryler..TMember as m on m.USER_ID = s.USER_ID"
  4. + " where o.COMPANY_CODE = '"+company_code.SelectedValue+"'"
  5. + " and cast(datepart(year, o.study_start) as varchar) + cast(datepart(month,o.STUDY_START) as varchar) = cast(datepart(year,'"+datepicker.text+"') as varchar) + CAST(DATEPART(month, '"+datepicker.Text+"') as varchar)"
  6. + " and o.TITLE not like '%재수강%'"
  7. + " and s.state ='1'";
Add Comment
Please, Sign In to add comment