I have a SQL query:
ALTER PROCEDURE dbo.GetDownloadDetails_Date
SELECT StatusDate, ProgramName, UserFullName, LoginName, CostCenterCode, EmailAddress, Phone, Manager, ComputerName, SCCMSiteCode, Status,
WHERE StatusDate BETWEEN @Startdate AND @EndDate
ORDER BY StatusDate
If the user selects a date range, the last day isn't populated, or if they select a single date, that date isn't displayed. I know the reason as it's because the Statusdate is a DateTime...I manually entered, for the @EndDate 04-10-2011 23:59:00 for
the @EndDate and the report generated.
So my question is how can I automatically update the @EndDate to include the time 23:59:00?
View Complete Post