select bk_bookg_t.bgt_member_no,BK_DEPARTMENT_R.bdr_dpm_name,bk_bookg_t.bgt_in_date,bk_bookg_t.bgt_out_date from bk_bookg_t,bk_department_r where bk_bookg_t.bgt_status is null and bk_bookg_t.bgt_member_no = bk_department_r.bdr_dpm_code and BGT_OUT_DATE >= TO_DATE('" & date_st.Value.Date & "','dd/mm/yyyy') and BGT_IN_DATE <= TO_DATE('" & date_end.Value.Date & "','dd/mm/yyyy') and BK_DEPARTMENT_R.bdr_dpm_name LIKE '%" & TxtSearch.Text & "%'
Load balance : Server 03
