i have a Stored Procedure,which takes two date parameters and returns values.
Part of my procedure is :
DECLARE @startdate datetime
DECLARE @enddate datetime
SELECT prmykey,min(seqnum) min_seq
INTO #min_seqnum from audit
WHERE prmytable = 'secmaster'
AND code = 1
AND name = 'Security'
AND entrydate Between @startdate and @enddate
When i execute the procedure with different @startdate and @enddate,it works fine.
But when i give the same date to both @startdate and @enddate it is not returning any data.
Example EXEC my_proc '1/1/2006','1/1/2006' doesnot return any data,even tough there is data for that date.
did anybody encounter something like this,or know the solution?
Please let me know.