| Author |
Message |
    
Gochi
Bewarse Legend
Username: Gochi
Post Number: 19960
Registered: 07-2004
Posted From: 71.234.232.47
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, May 04, 2006 - 7:34 pm: |    |
 junction maama...nenu kooda Cognos loney workings of USA |
Junction_jam_avudhi
Pilla Bewarse
Username: Junction_jam_avudhi
Post Number: 8
Registered: 05-2006
Posted From: 75.4.135.131
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, May 04, 2006 - 6:58 pm: | |
hello helllllo....talugu mamalu....
nenu .kotha...
naaku chinna salaha ichi.punyam kattukora...
COGNOS reportnet lo future ela untundho cheppandhi...
 |
Leo2leo
Pilla Bewarse
Username: Leo2leo
Post Number: 67
Registered: 09-2004
Posted From: 210.143.35.17
Rating:N/A
Votes: 0(Vote!) | | Posted on Friday, June 17, 2005 - 2:06 am: | |
good news mama.....
nenu kuda vundedi BAY AREA lone mama..kani TOKYO BAY ...nijam ga....
seminar ayyaka contents kani edanna sitelo pettetaiyite....ikadda linketti punyam kattuko mama...
adi grand success kavalani asistuuu... |
Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk
Post Number: 270
Registered: 06-2005
Posted From: 68.164.80.31
Rating:N/A
Votes: 0(Vote!) | | Posted on Friday, June 17, 2005 - 1:46 am: | |
NEXT MONTH SANTACLARA CONVENTION CENTRE LO SQL AND DATA DESIGN INFRASTUCTURE , DATA WAREHOUSE DESIGN TECHNICS MEEDA LECTURE ISTUNNA MAMA. MANA BAY AREA BEWARSE ANDARINI INVITE CHEDDAM ANUKONTUNNA.
I AM GOING TO SHOW BO ( BUSINESS OBJECTS ) SEMINAR FOR INFORMATICA DESIGN PATTERNS -- OKA EXAMPLE TO ISTUNNA. -- IDI MERCURY NEWS VALLA DABBULA TO CONDUCT AVUTONDI.
INTEREST UNNAVALLU NAAKU MAIL KOTTANDI. |
Leo2leo
Pilla Bewarse
Username: Leo2leo
Post Number: 66
Registered: 09-2004
Posted From: 210.143.35.14
Rating:N/A
Votes: 0(Vote!) | | Posted on Friday, June 17, 2005 - 1:39 am: | |
Bunk mama ..
endukala petrol la baggu mantav...a initiator babai optimizer...migata vatimida manaki vydea ledu ganda...andukani edo oka vuchita salaha vodila
endo mama aa "Technology - Talk Only Tech" ki eldamanukune lope ee tokkalo "Cinema" section link clickk ayipointandi (intelli Mouse kada..Mouse mata vinadu.. )...kani ee section lo tech tadulante janalu sepittarani guilty peeling.....sarle malla inkeppudaina malla collections chusi ni quiz loki vasta.... |
Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk
Post Number: 253
Registered: 06-2005
Posted From: 68.164.80.31
Rating:N/A
Votes: 0(Vote!) | | Posted on Friday, June 17, 2005 - 1:07 am: | |
nee yankamma, nenu 1 million rows meeda explain plan choosa naa query 476 points lo undi. No hash join or worst join.
1 million rows meeda FOR NOT IN explain plan giving 994 points.
Munde cheppa number of records and primary key meeda dependent ayyi untundi.
Informatica lo ee query ni operate chese chooste super performance leo mama. I remember your 5 POINTS FOR MY NEXT SQL QUIZ aa tadu ni piki teesuku raa. |
Leo2leo
Pilla Bewarse
Username: Leo2leo
Post Number: 65
Registered: 09-2004
Posted From: 210.143.35.14
Rating:N/A
Votes: 0(Vote!) | | Posted on Friday, June 17, 2005 - 12:33 am: | |
SQL> select emplid, to_char(dt, 'dd-MON-yyyy') "date" , hours from avinash_btdb;
EMP date HOURS
--- ----------- ----------
100 14-MAY-2005 20
100 28-MAY-2005 40
100 11-JUN-2005 60
200 14-MAY-2005 20
200 11-JUN-2005 60
300 14-MAY-2005 20
300 28-MAY-2005 40
300 11-JUN-2005 60
400 14-MAY-2005 20
400 11-JUN-2005 60
10 rows selected.
SQL> update avinash_btdb
2 set dt = to_date('28-MAY-2005', 'DD-MON-YYYY')
3 where dt = to_date('11-JUN-2005', 'DD-MON-YYYY')
4 and emplid not in
5 (select emplid
6 from avinash_btdb
7 where dt = to_date('28-MAY-2005', 'DD-MON-YYYY'))
8 /
2 rows updated.
SQL> select emplid, to_char(dt, 'dd-MON-yyyy') "date" , hours from avinash_btdb;
EMP date HOURS
--- ----------- ----------
100 14-MAY-2005 20
100 28-MAY-2005 40
100 11-JUN-2005 60
200 14-MAY-2005 20
200 28-MAY-2005 60
300 14-MAY-2005 20
300 28-MAY-2005 40
300 11-JUN-2005 60
400 14-MAY-2005 20
400 28-MAY-2005 60
10 rows selected.
************************************************** ************
Avinash mayya....climax ayyaka polisollochchinattu...yedenti ii post anukomakey (my time UTC+9hrs & db F5 frequency takkuva).... edo GULA koddi post chesa...
Bunk babai cheppina query konchem performance levello chuste konchem kashtam ani peeling....
Bunk babai suggest chesinattu Gula statmnt ki condition add chesukotam better....
Bunk babai monnedo 3 istananni atta patta ledu.. |
Tifosi
Mudiripoyina Bewarse
Username: Tifosi
Post Number: 4655
Registered: 03-2004
Posted From: 208.37.228.208
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 4:06 pm: | |
insert into cust_tbl values(name, select city from address_tbl where cust_id='123')
ila cheyyochha |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 4731
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:51 pm: | |
Nee Yenkhs add evadu sesukomannadu mail pampu salu |
Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk
Post Number: 133
Registered: 06-2005
Posted From: 209.172.81.133
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:50 pm: | |
Only Ammayila Id ayite add chesukonta  |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 4727
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:42 pm: | |
Mundu Jaraga valasina pani choodu >>
Same 2 Same mundu naku mail pampu
sinnabtdb@yahoo.com |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 4726
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:41 pm: | |
Enti Bunk mama mari naku cheppamanna ekkada choodali ani best e site e book lo Qureies gurinchi details untayyi ani koosantha mailin anna seyyaradu mama |
Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk
Post Number: 132
Registered: 06-2005
Posted From: 209.172.81.133
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:41 pm: | |
Gatam Gataha, Old nick ni marchipo Avinash mama.
Mundu Jaraga valasina pani choodu |
Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk
Post Number: 131
Registered: 06-2005
Posted From: 209.172.81.133
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:40 pm: | |
Sinna  |
Avinash
Pilla Bewarse
Username: Avinash
Post Number: 78
Registered: 03-2005
Posted From: 209.234.142.80
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:40 pm: | |
Gula mama, Oracle
Bank mama nuvvu mana Rjy vaa? |
Gula
Mudiripoyina Bewarse
Username: Gula
Post Number: 3553
Registered: 06-2004
Posted From: 69.109.221.118
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:38 pm: | |
avinash babai needi sql server? leka oracle? |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 4722
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:32 pm: | |
Adigadigo vachadayya SQL king..
Andariki cpethadu naku mathram adiginadiniki cepadu  |
Petrol_bunk
Pilla Bewarse
Username: Petrol_bunk
Post Number: 130
Registered: 06-2005
Posted From: 209.172.81.133
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:31 pm: | |
update accrual_tbl set date=to_date('28-MAY-2005','DD-MON-YYYY')
where date=to_date('11-JUN-2005,,'DD-MON-YYYY') and emplid in (
select emplid from accrual_tbl
where date = to_date('11-JUN-2005','DD-MON-YYYY')
minus
select emplid from accrual_tbl
where date = to_date('28-MAY-2005','DD-MON-YYYY')
)
Ee query kooda work avutundi.
Small correction to Gula mama query ekkadaina Date unte to_date('5/28/2005','MM/DD/YYYY') pettu
Ee scenario lo emi cheyyamantavu?
700 14-MAY-2005 20
700 11-JUN-2005 60
700 11-JUN-2005 40
700 11-JUN-2005 80
Ikkada Okka 11-JUN ni update cheste chala ( because okka row update ayina 28-MAY-2005 record vochhestundi ) migilina 11-JUN-2005 records la BATUKU BUSSTAND ayipotundi |
Gula
Mudiripoyina Bewarse
Username: Gula
Post Number: 3551
Registered: 06-2004
Posted From: 69.109.221.118
Rating:
Votes: 1(Vote!) | | Posted on Thursday, June 16, 2005 - 12:08 pm: | |
hemu ala ani kadu......nuvvu edanna company lo cherithe nuvvu nee comp info ee okak mukka baita pettanu ani sign chesthavu.......porapatuna dorikithe siruggi sembu seta kuda |
Rediff
Mudiripoyina Bewarse
Username: Rediff
Post Number: 4212
Registered: 03-2004
Posted From: 159.37.7.93
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:08 pm: | |
sethaara enti.. nee enkamma.. worst cases konni vuntaaya.. eppudu elaa daapuristaayo cheppalem kadaa.. |
Avinash
Pilla Bewarse
Username: Avinash
Post Number: 77
Registered: 03-2005
Posted From: 209.234.142.80
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:07 pm: | |
Gula thanks for ur quick response. I am testing ur query
The tablenames I gave are False. |
Hemanthchowdary
Mudiripoyina Bewarse
Username: Hemanthchowdary
Post Number: 2676
Registered: 04-2005
Posted From: 63.110.106.226
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 12:03 pm: | |
emaindi table names septhe, ikkada nunchi access setharaa?? |
Gula
Mudiripoyina Bewarse
Username: Gula
Post Number: 3550
Registered: 06-2004
Posted From: 69.109.221.118
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 11:59 am: | |
galio neeku ekkuva anukunta? |
Gaali
Celebrity Bewarse
Username: Gaali
Post Number: 6729
Registered: 03-2004
Posted From: 199.26.230.102
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 11:58 am: | |
Banda mama
Neeku Gulaswami meda confidence takkuva anukontaa. |
Gula
Mudiripoyina Bewarse
Username: Gula
Post Number: 3548
Registered: 06-2004
Posted From: 69.109.221.118
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 11:56 am: | |
avinash babai for anyreason porapatuna kuda nee table names baita pettamaku
vatiki perulu marchi pettu db lo vesetappudu
banda mama |
Banda
Pilla Bewarse
Username: Banda
Post Number: 89
Registered: 11-2004
Posted From: 65.208.22.26
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 11:54 am: | |
i think the one posted by sollu mama shud work |
Gula
Mudiripoyina Bewarse
Username: Gula
Post Number: 3546
Registered: 06-2004
Posted From: 69.109.221.118
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 11:53 am: | |
update tbl
set date = '5/28/2005'
WHERE date = '6/11/2005'
AND id NOT IN
(
Select id from tbl where date = '5/28/2005')
idi try cheyyi babai |
Rediff
Mudiripoyina Bewarse
Username: Rediff
Post Number: 4210
Registered: 03-2004
Posted From: 171.72.5.133
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 11:52 am: | |
Where clause lo second select clause pettu mama.. |
Avinash
Pilla Bewarse
Username: Avinash
Post Number: 76
Registered: 03-2005
Posted From: 209.234.142.80
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, June 16, 2005 - 11:48 am: | |
Table Name ACCRUAL_TBL
EMPLID DATE HOURS
100 14-MAY-2005 20
100 28-MAY-2005 40
100 11-JUN-2005 60
200 14-MAY-2005 20
200 11-JUN-2005 60
300 14-MAY-2005 20
300 28-MAY-2005 40
300 11-JUN-2005 60
400 14-MAY-2005 20
400 11-JUN-2005 60
Update the 11-JUN-2005 row to 28-MAY-2005 ROW If there is no 28-MAY-2005 Row
If there is a 28-MAY-2005 row already do not update the 11-JUN-2005 Row
I need to update 100000 rows
In the above 200 and 400 should be updated to
200 14-MAY-2005 20
200 28-MAY-2005 60
400 14-MAY-2005 20
400 28-MAY-2005 60
AND 100 AND 200 SHOULD NOT CHANGE
100 14-MAY-2005 20
100 28-MAY-2005 40
100 11-JUN-2005 60
300 14-MAY-2005 20
300 28-MAY-2005 40
300 11-JUN-2005 60
Answer telisthe cheppandi!!
TIA |
