Viewing 3 posts - 1 through 4 (of 4 total)
I had to use the CASE statement so that the 'report' would work after midnight. For example,if the report is ran before 3PM, the start time will be...
April 26, 2018 at 10:04 am
#1988382
For anyone that may need something like this in the future. Here's the code I came up with.
SELECT ActualW, LineDate, NewDate, Description,...
April 25, 2018 at 1:56 pm
#1988257
After further researching....
Local variables are not allowed in a VIEW. 🙁
April 24, 2018 at 3:53 pm
#1988128