Hello,
I am really not having luck with this statement. I am receiving no output
and I honestly thought that this command would do it. It is giving me
problems with the WHERE (node_name...) Does anyone know what I am doing
wrong? Thanks!
SELECT node_name, scheduled_start, schedule_name, status
FROM events
WHERE (node_name LIKE 'HMCH%' OR node_name LIKE 'HMPG%')
AND scheduled_start > getdate() - 1
ORDER BY node_name
Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338
|