I am trying to use the Web Assistant Wizard to run the script below and it is failing. it doesn't seem to like the (parentheses) or [brackets] or datediff. so I am not sure what to do. Any insight working with Web Assistant Wizard would be appreciated.
wfd1bdb
SELECT SSNO as AccountNo, VARTXT as DateOffered, PROV as Provider, convert(varchar(10), reported, 101)
as CallReceived, datediff(dy,reported,vartxt) as DaysBetween
FROM DICTIONARY
WHERE ([SCTION] = 'Cenntk') AND (VARCODE IN ('ofrdapt'))
AND (COMPANY = 'mn')and reported between '01-01-2007' and '02-01-2007' and
datediff(dy,reported,vartxt) > -1
ORDER BY SSNO, vartxt, REPORTED
wfd1bdb
SELECT SSNO as AccountNo, VARTXT as DateOffered, PROV as Provider, convert(varchar(10), reported, 101)
as CallReceived, datediff(dy,reported,vartxt) as DaysBetween
FROM DICTIONARY
WHERE ([SCTION] = 'Cenntk') AND (VARCODE IN ('ofrdapt'))
AND (COMPANY = 'mn')and reported between '01-01-2007' and '02-01-2007' and
datediff(dy,reported,vartxt) > -1
ORDER BY SSNO, vartxt, REPORTED