Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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"
- + " inner join tryler..TSukang as s on s.OPEN_ID = o.OPEN_ID"
- + " inner join tryler..TMember as m on m.USER_ID = s.USER_ID"
- + " where o.COMPANY_CODE = '"+company_code.SelectedValue+"'"
- + " 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)"
- + " and o.TITLE not like '%재수강%'"
- + " and s.state ='1'";
Add Comment
Please, Sign In to add comment