June 11, 2012 at 4:29 am
DEAR ALL
I HAVE TO CREATE THE REPORT
I HAVE CALCULATE THE INCREMENTAL /DECREMENTAL (JOINEE/EXIT) EMPLOYES IN SQL SERVER
MY TABLE STRUCTURE IS
EID DATE
10 2012-APR-2012
10 2012-APR-2012
20 2012-APR-2012
30 2012-MAY-2012
31 2012-MAY-2012
32 2012-MAY-2012
33 2012-mAY-2012
MY EXPECTED OUT PUT IS
APR : 200
MAY : 222
JUNE :189
JULY :155
AUT :300
.
.
.
ANY BODY KNOW THE LOGIC EXPLAIN TO ME
.
DEC :4000
June 11, 2012 at 4:33 am
First, please may I say that you need to switch caps lock off.
Second please follow the second link in my signature on how to post code and data for the best results.
Third you have not detailed how the calculation needs to take place in order to get your expected outcome.
June 11, 2012 at 4:53 am
anthony.green (6/11/2012)
First, please may I say that you need to switch caps lock off.Second please follow the second link in my signature on how to post code and data for the best results.
Third you have not detailed how the calculation needs to take place in order to get your expected outcome.
+1
Where are the values for all the months coming from??....
June 11, 2012 at 9:55 am
kond.mohan (6/11/2012)
DEAR ALLI HAVE TO CREATE THE REPORT
I HAVE CALCULATE THE INCREMENTAL /DECREMENTAL (JOINEE/EXIT) EMPLOYES IN SQL SERVER
MY TABLE STRUCTURE IS
EID DATE
10 2012-APR-2012
10 2012-APR-2012
20 2012-APR-2012
30 2012-MAY-2012
31 2012-MAY-2012
32 2012-MAY-2012
33 2012-mAY-2012
MY EXPECTED OUT PUT IS
APR : 200
MAY : 222
JUNE :189
JULY :155
AUT :300
.
.
.
ANY BODY KNOW THE LOGIC EXPLAIN TO ME
.
DEC :4000
And your dates aren't dates, YYYY-Mon-YYYY.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply