Datasource:emp
Template:NON_EXEPemp.htx
SQLStatement:SELECT distinct emptype, mid([emptype],11,60) as emptype1
+FROM JobDisplay
+Where emptype='12 Non Ex-Trades, Maintenance, FoodServ, Housekeep'
SQLStatement:SELECT *, Left([postingdate],10) as displaypostingdate, Left([closingdate],10) as displayclosingdate
+FROM JobDisplay
+Where postingdate<=Date() and emptype='12 Non Ex-Trades, Maintenance, FoodServ, Housekeep' 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='12 Non Ex-Trades, Maintenance, FoodServ, Housekeep' and closingdate >=Date() and closingdate >Time()
+Order by FunctionalTitle ASC, dept ASC;




Password:
Username: