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