stored procedure

[angela4eva]

I have a stored procedure and there have been some isuues recarginf the dates and i have to hordcode some dates ..can any one please let me know how i can accomplish times
here is my stored proc.can i write a conditional if..

@startdate datetime
@enddate datetime
select number1,name from log where transdate>=@startdate and transdate<@enddate

---here what i need to accomplish

@startdate datetime
@enddate datetime
---if @startdate='11/19/2006' and @enddate='11/20/2006' then
select number1,name from log where transdate>='11/20/2006 1:00pm' and transdate< '11/20/2006'
-------if @startdate='11/20/2006' and @enddate='11/21/2006' then
select number1,name from log where transdate>='11/20/2006 1:00pm' and transdate< '11/20/2006'
default
select number1,name from log where transdate>=@startdate and transdate<@enddate

 

[SQLBill]

Ok....first things first here.........

Any date without a time defaults as 00:00:00.000. So,

select number1,name 
from log 
where transdate>='11/20/2006 1:00pm' 
  and transdate< '11/20/2006'

is really:

select number1,name 
from log 
where transdate>='11/20/2006 1:00pm' 
  and transdate< '11/20/2006 00:00:00.000'

Which I'm sure ISN'T what you want as no data will match that. So, what endtime do you really want?

-SQLBill



Posting advice: FAQ481-4875