conversion faild when converting date time from charachter sting
stored procedure as followingCreate proc searchData
@StartDate datetime,
@EndDate datetime
as
Declare @SQLQuery as nvarchar(2000)
SET @SQLQuery ='SELECT * from Employee Where (1=1)'
If (@StartDate is not NULL) AND (@EndDate is not NULL)
Set @SQLQuery = @SQLQuery + ' And (JoinDate
BETWEEN '+ @StartDate +' AND '+@EndDate+')'
Exec (@SQLQuery)
JoinDate found in table Employee as datetime
but when i make stored procedure as following
it work in formate dd/mm/yyyy and this is what i need
ALTER proc [dbo].[searchData]
@StartDate datetime
@EndDate datetime,
as
Now what is the proplem in first stored procedure
Please help me if possible
Saineshwar BageriPosted Sep 1, 2014, 1:25 PM
alter proc searchData
@StartDate datetime,
@EndDate datetime
as
Declare @SQLQuery as nvarchar(2000)
SET @SQLQuery ='SELECT * from Employee Where (1=1)'
If (@StartDate is not NULL) AND (@EndDate is not NULL)
select @SQLQuery = @SQLQuery + ' And (JoinDate
BETWEEN '''+ CONVERT(varchar(10), @StartDate, 111) +''' AND '''+CONVERT(varchar(10), @EndDate, 111) +''')'
PRINT @SQLQuery
Exec (@SQLQuery)
Mark as answer if i helped you
ahmed saPosted Sep 2, 2014, 8:59 AM
ahmed saPosted Sep 2, 2014, 2:16 AM
but if i make >=
and <= how i do that
meaning
If
Set @SQLQuery = @SQLQuery + ' And (joindate >= '''+ Cast(@StartDate as varchar(100))
If (@EndDate is not NULL)
Set @SQLQuery = @SQLQuery + ' And (joindate <= '''+ Cast(@EndDate as varchar(100))
if i need to do as above what i will change because my query require >= or <=
if possible help me
(@StartDate is not NULL)