4
Reply

Select dates between two dates using isnull function

Prasad Bhagat

Prasad Bhagat

Jun 23 2015 2:53 AM
524
Dear All,
 
 
i have procedure like bellow
 
create proc usp_abc
@fromdate datetime,
@todate datetime
as
begin
select * from tbl 
 
whete 
 (CONVERT(datetime,(select exit_status_Date from dbo.tbl_param_employee_exit_track where employee_d=tbl_param_employee_master.ID),103) between @fromdate and @todate)
 
i want to fetch all records between two dates if dates are null also
 

Answers (4)