Create Procedure [dbo].[GetEmployeesDates]
@StartDate as varchar(50),
@EndDate as varchar(50)
as
begin
SELECT *
FROM [ERS].[dbo].[employee] where Date>=@StartDate and date<@EndDate
now
if i pass the parameters i need get the date between range
and also i need to get the date without passing the parameters
how can i do this one
please help me
thanks