Home » RDBMS Server » Server Administration » No of days depts were vacant
No of days depts were vacant [message #373723] |
Wed, 02 May 2001 15:56 |
Aneeta
Messages: 1 Registered: May 2001
|
Junior Member |
|
|
Hi,
I have a problem
the user wants to know how many days the depts were vacant.
For ex
depts table looks like some thing like this
emplid deptcd transfer date completion dt
22222 A 1/jan1/2001
1111 A 2/may/2000 2/nov/2000
3333 a 2/feb/1999 2/feb/2000
It was occupied on 2/feb/1999 through 2/feb/2000.
And was vacant till 2/apr/2000(3 months) and than ocuupied from
2/apr/2000 to 2/nov/2000 and then vacant till 1/jan1/2001(vacant for 2 months).And so on ....
I have to find the no of vacancy for each dept .Any idea
Thansk
ANita
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Jan 13 07:43:51 CST 2025
|