| Author |
Message |
    
Bhupathi
Pilla Bewarse
Username: Bhupathi
Post Number: 451
Registered: 05-2005
Posted From: 69.233.97.54
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 7:15 pm: |    |
Ravana mama,
MAX EFF_DT (Effective Date) use cheyyi mama...You need to use only only 1 query.
Inka specific listing kavali ante...ACTION/ REASON fields untayi for TRANSFERS
Are you prepared for the Dollar Crash?. If not, run baby run !! |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6555
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 6:27 pm: | |
 |
Rrc
Yavvanam Kaatesina Bewarse
Username: Rrc
Post Number: 4453
Registered: 04-2006
Posted From: 70.103.105.131
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 6:09 pm: | |
 database tycoons ikkada.........
manaki enduku.....elli vastha.....
Palace on wheels exclusively for apes..coming soon ...delayed ...coming soon ....delayed again ...never mind |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6554
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 5:46 pm: | |
beeresh..nuvvu cheppina query ne work avuthundi  |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6546
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 10:44 am: | |
oh ok beeresh.
pda mama...yeh start_date and end date undi...kaani basic ga state date end date (less than sysdate) unte status T untadi even trasfer ayina sare. aa transfer ayina vadu vere branch lo unte term date future date 2034 or null untadi with the status A |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3784
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 10:28 am: | |
adi kooda work avutundi. kani.. if you want to make sure the employee exists with active status, use my qry
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Pda
Celebrity Bewarse
Username: Pda
Post Number: 21059
Registered: 06-2006
Posted From: 129.138.250.120
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 10:26 am: | |
table lo emanna date fields like eff_date, term_date etc. vunte dani batti query rayatam better.. 99% of the time, you will have employees with future termination dates, and you don't want to miss those.
Everything should be made as simple as possible, but no simpler. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6545
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 10:25 am: | |
select * from employees a
where a.employee_status = 'T'
and a.employee_id not in (select b.employee_id from employees b
where a.employee_id = b.employee_id
and employee_status != 'T')
idi terminated employees list isthademo ga?? work avuthunda? |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6544
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 10:23 am: | |
select * from employee
where status != 'T'
ante active employee list vasthadi ga..
active unnodiki elagu A ani untadi
transfer ayyadu ante T and A records untay..andulo oka record ki A untadi kabatti vadu active ee...
idi work avuthundemoga? |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3782
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 10:20 am: | |
id ante employee id.. the qry will give u active employees
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3781
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 10:19 am: | |
select * from emp a where status = 'A' and not exists (select 1 from emp b where a.id = b.id
and b.status = 'T');
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6543
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Monday, April 28, 2008 - 10:15 am: | |
naaku oka employee table undi. andulo employee_status A and T undochu
A ante Active
T ante Terminated.
ippudu oka employee transfer ayithe 2 records untay. oka record status T undi vere record lo sttaus A untadi.
ippudu naku employee listing kavali like who are active and who are terminated?
ela rayali query? 2, 3 querie separate ga like active employees, terminated employees ala raasina okk.  |
