Datasource:emp
Template:NON_EXEPemp.htx
SQLStatement:SELECT distinct emptype, mid([emptype],11,40) as emptype1
+FROM JobDisplay
+Where emptype='11 Non Ex-Clerical and Office Support'
SQLStatement:SELECT *, Left([postingdate],10) as displaypostingdate, Left([closingdate],10) as displayclosingdate
+FROM JobDisplay
+Where postingdate<=Date() and emptype='11 Non Ex-Clerical and Office Support' and closingdate >=Date() and closingdate >Time()
+Order by FunctionalTitle ASC, dept ASC
SQLStatement:SELECT *, Left([postingdate],10) as displaypostingdate, Left([closingdate],10) as displayclosingdate
+FROM JobDisplay
+Where postingdate<=Date() and emptype='11 Non Ex-Clerical and Office Support' and closingdate >=Date() and closingdate >Time()
+Order by FunctionalTitle ASC, dept ASC;




Password:
Username: