please can someone help
the following statement does not run when its ad hoc parameter is populated.if it is left blank, it returns all values as normal.
thanks in advance.
andy
SELECT
Wo.wonum,
Wo.reportdate,
Wo.actlabhrs,
Wo.woassignmntqueueid,
Woass.description,
Wo.leadcraft,
La.name,
(CASE...