By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @employee TABLE(
Emp VARCHAR(100),
DOB datetime
)
INSERT INTO @employee SELECT 'ABC','1991-03-01'
INSERT INTO @employee SELECT 'XYZ','1992-12-01'
INSERT INTO @employee SELECT 'AJM','1992-08-20'
INSERT INTO @employee SELECT 'RNM','1991-07-10'
DECLARE @StartDate datetime = '2020-03-01';
DECLARE @EndtDate datetime = '2020-03-01';
DECLARE @employeeResultFinal TABLE(
Emp VARCHAR(100),
DOB datetime
)
IF(DAY(@StartDate)) =DAY(@EndtDate)
begin
IF(MONTH(@StartDate)) =MONTH(@EndtDate)
begin
IF(YEAR(@StartDate)) !=YEAR(@EndtDate)
begin
select * from @employee
goto Result;
end
end
end
| Emp | DOB |
|---|---|
| ABC | 1991-03-01 00:00:00.000 |
DECLARE @employee TABLE(
Emp VARCHAR(100),
DOB datetime
)
INSERT INTO @employee SELECT 'ABC','1991-03-01'
INSERT INTO @employee SELECT 'XYZ','1992-12-01'
INSERT INTO @employee SELECT 'AJM','1992-08-20'
INSERT INTO @employee SELECT 'RNM','1991-07-10'
DECLARE @StartDate datetime = '2020-01-01';
DECLARE @EndtDate datetime = '2020-03-20';
DECLARE @employeeResultFinal TABLE(
Emp VARCHAR(100),
DOB datetime
)
IF(DAY(@StartDate)) =DAY(@EndtDate)
begin
IF(MONTH(@StartDate)) =MONTH(@EndtDate)
begin
IF(YEAR(@StartDate)) !=YEAR(@EndtDate)
begin
select * from @employee
goto Result;
end
end
end
| Emp | DOB |
|---|---|
| ABC | 1991-03-01 00:00:00.000 |
DECLARE @employee TABLE(
Emp VARCHAR(100),
DOB datetime
)
INSERT INTO @employee SELECT 'ABC','1991-03-01'
INSERT INTO @employee SELECT 'XYZ','1992-12-01'
INSERT INTO @employee SELECT 'AJM','1992-08-20'
INSERT INTO @employee SELECT 'RNM','1991-07-10'
DECLARE @StartDate datetime = '2020-03-01';
DECLARE @EndtDate datetime = '2021-01-15';
DECLARE @employeeResultFinal TABLE(
Emp VARCHAR(100),
DOB datetime
)
IF(DAY(@StartDate)) =DAY(@EndtDate)
begin
IF(MONTH(@StartDate)) =MONTH(@EndtDate)
begin
IF(YEAR(@StartDate)) !=YEAR(@EndtDate)
begin
select * from @employee
goto Result;
end
end
end
| Emp | DOB |
|---|---|
| ABC | 1991-03-01 00:00:00.000 |
| XYZ | 1992-12-01 00:00:00.000 |
| AJM | 1992-08-20 00:00:00.000 |
| RNM | 1991-07-10 00:00:00.000 |