Hi, How to get the Employee Year Wise Depend upon Joining Resigning and Status. The Table is given below. CREATE TABLE [dbo].[Employee]( [Emp_No] [numeric](18, 0) NULL, [Emp_Number] [nvarchar](50) NULL, [Emp_Name] [nvarchar](50) NULL, [Emp_JoiningDate] [date] NULL, [Emp_ResignDate] [date] NU…

[image] bitsmed: declare @start_dt date=( select cast(dateadd(year,datediff(year,0,min([emp_joiningdate])),0) as date) from employee ); with cte_dt(dt) as (select top(datepart(year,current_timestamp)-datepart(year,@start_dt)+1) dateadd(year,row_number() over(order by (select null))-1,@star…

How to get the Employee Year Wise Depend upon Joining Resigning and Status

Transact-SQL

basit0079 September 27, 2017, 2:37pm 8

can you please check below link.