ssql = "SELECT Temp_Portal.SectionCode, Temp_Portal.nr_workcode, Temp_Portal.Order_Number, Temp_Portal.Item_Number, " & _ "tbl_WC_FWBS.FWBS_Code, tbl_WC_FWBS.FWBS_Application, Temp_Portal.Project_Total, tbl_Department.dept_name, " & _ "Temp_Portal.Project, Temp_Portal.Billing_Month, Temp_Portal.Billing_Year " & _ "FROM MTS_Portal.dbo.tbl_WC_FWBS tbl_WC_FWBS INNER JOIN (MTS_Portal.dbo.tbl_Department tbl_Department INNER JOIN MTS_Portal.dbo.Temp_Portal Temp_Portal ON tbl_Department.department_id=Temp_Portal.Dept_ID) ON tbl_WC_FWBS.Work_Code=Temp_Portal.Work_Code " & _ "WHERE Temp_Portal.Project_Code='" & gProjectCode & "' AND Temp_Portal.IsBillable='1' " & _ "ORDER BY tbl_Department.dept_name, Temp_Portal.Project, Temp_Portal.nr_workcode "
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)