I want to calculate no of month from date of joining from employee

Question

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
 while(@Count1<=@count)
 begin
 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())) 
 --CASE
 --  WHEN DATEPART(day, @DOJ) > DATEPART(day, getdate()) THEN 1 ELSE 0
 --END
 print @COuntdate 
 END
 set  @Count1=@Count1+1

but it gives error

Posted 11-Oct-17 3:15am

paul_vin

Updated 11-Oct-17 4:49am

Add a Solution

Comments

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Answer 1 · 2017-10-11T04:49:00

Solution 2

If i understand you well...

It should be something like this:

SQL

SELECT SUM(T.NoOfMonthsOfDOJ) AS TotalMonths
FROM (
    SELECT DATEDIFF(MONTH, DOJ, CONVERT(DATE, GETDATE())) AS NoOfMonthsOfDOJ --number of months for each employee
    FROM TmpTable
) AS T

Posted 11-Oct-17 4:49am

Maciej Los