SELECT pvd.* ,'' AS Reading1, '' Reading2,IFNULL(pvd.severity,0) AS Sev
FROM #Request.prefix_db_agency#.pProgress pvd
LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules si ON pvd.Schedule_ID = si.Schedule_ID
WHERE -- pvd.Schedule_ID = #url.p#
AND pvd.Description = '#url.t#'
AND pvd.status = 0
AND si.Visit_Date = '#thedate#'
GROUP BY pvd.Schedule_ID
#ucase(Description)#
| Date: | #url.d# |
| Severity: | #Sev# |
| Notes: | #Notes# |
SELECT pvd.* ,'' AS Reading1, '' Reading2,IFNULL(pvd.severity,0) AS Sev
FROM #Request.prefix_db_agency#.pProgress pvd
LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules si ON pvd.Schedule_ID = si.Schedule_ID
WHERE pvd.Assmt_ID = #url.p#
AND (pvd.Description = '#url.t#' OR pvd.Description = '###url.t#')
AND pvd.status = 0
AND si.Visit_Date = '#thedate#'
#ucase(Description)#
| Date: | #url.d# |
| Value_1: | #Value_1# |
| Reading 1: | #Reading1# |
| Reading 2: | #Reading2# |
| Notes: | #Notes# |