2
Answers

How to get the range between dates in sql server

Mahesh Babu

Mahesh Babu

6y
475
1
I Created one stored procedure 
 
 
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 
Answers (2)