The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.
ALTER PROC [dbo].[spNC_BookingWizard] @StartDate varchar(10) = '1/1/1900', @EndDate varchar(10) = '1/1/2010', @Employee varchar(200) = '', @Facility varchar(200) = '', @Status varchar(200) = '', @test bit = 0 AS SET NOCOUNT ON DECLARE @dtStart datetime DECLARE @dtEnd datetime SET @dtStart = CONVERT(datetime, @StartDate) SET @dtEnd = DATEADD(dd, 1, DATEADD(dd, 0, CONVERT(datetime, @EndDate))) ........... SELECT * FROM #tmpBook WHERE StartDate_date >= @dtStart AND StartDate_date <= @dtEnd AND Facility = @Facility AND EmpName = @Employee AND BookingStatus = @Status
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.