Click here to Skip to main content
15,667,829 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have temp table which has following data
Id	UserId	UserFirstName	DOJ	Location
1	5	Ashvini	2016-05-03 00:00:00.000	Mumbai
2	18	Deepak	2016-06-13 00:00:00.000	Mumbai
3	23	Devesh	2016-05-02 00:00:00.000	Mumbai
4	25	Dibyajyoti Arabinda	2016-07-06 00:00:00.000	Mumbai
5	27	Gaurav	2016-08-16 00:00:00.000	Mumbai
6	38	Izhar	2016-05-23 00:00:00.000	Mumbai
7	39	Jacob	2016-04-21 00:00:00.000	Mumbai
8	47	Mamun Al	2016-08-04 00:00:00.000	Mumbai
9	49	Manoj	2016-08-22 00:00:00.000	Mumbai
10	54	Nagesh	2016-06-01 00:00:00.000	Mumbai
11	55	Namit	2016-07-04 00:00:00.000	Mumbai

Now I want to calculate total number of month from Date of joining to today date

What I have tried:

Declare @count int,@Count1 int, @DOJ datetime,@COuntdate int,@Id int

 set @count =(select count(UserID) from #MyTemp1)
 set @Count1=1
 set @Id=(select Id from #MyTemp1 where Id=@Count1)
 set @DOJ = (select DOJ from #MyTemp1 where @Id=@Count1)

set @COuntdate= (select DATEDIFF(MONTH, (select DOJ from #MyTemp1 where Id=@Count1),GETDATE()) as Vintage)

 --set @COuntdate= (select DATEDIFF (month, @DOJ, getdate())) 
 --  WHEN DATEPART(day, @DOJ) > DATEPART(day, getdate()) THEN 1 ELSE 0
 print @COuntdate 
 set  @Count1=@Count1+1

but it gives error
Updated 11-Oct-17 4:49am
F-ES Sitecore 11-Oct-17 9:42am    
If you don't think the error message is relevant to solving the problem then maybe you should take a different class?

1 solution

If i understand you well...

It should be something like this:
SELECT SUM(T.NoOfMonthsOfDOJ) AS TotalMonths
    SELECT DATEDIFF(MONTH, DOJ, CONVERT(DATE, GETDATE())) AS NoOfMonthsOfDOJ --number of months for each employee
    FROM TmpTable
) AS T
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900