Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets
Bewarse Talk Discussion Board * Archives - 2010 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through March 12, 2010 * SQL Query Help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12847
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 2:33 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

asalu sagam work DB volla setha sepinchesthunnaavgaa hemesh....ikkada BTDB lo oka kochen,PFDB lo okati,CCDB lo okati ilaa project manager lekka nee tasks ani janaalaki distributing chesthunnaavani colorado side correst info



ante ikkada thread vesthunte nenu sagam aalochinchestha :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

420
Celebrity Bewarse
Username: 420

Post Number: 9347
Registered: 12-2006
Posted From: 80.101.228.123

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 2:30 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

idedo bending chesey vyakthey kaani grease raasukuni bending chesey vyakthi kaadhu annattu undi....inkoka punch aaa



... sounds like a powerfull punch
Knit India,do not split India !
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 67003
Registered: 07-2004
Posted From: 148.168.127.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 1:10 pm:    Edit Post Delete Post View Post/Check IP
Nitho:

Gochi kustanni namme manishi, ammukune manishi kadhu



idedo bending chesey vyakthey kaani grease raasukuni bending chesey vyakthi kaadhu annattu undi....inkoka punch aaa

Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Celebrity Bewarse
Username: Onlymovies

Post Number: 8901
Registered: 01-2009
Posted From: 199.173.224.32

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 1:09 pm:    Edit Post Delete Post View Post/Check IP
Nitho:

Gochi kustanni namme manishi, ammukune manishi kadhu...

ante nuvvu ammuntunnava?
Sachin is the highest individual scorer in ODI.
Top of pagePrevious messageNext messageBottom of page Link to this message

Nitho
Celebrity Bewarse
Username: Nitho

Post Number: 7517
Registered: 12-2004
Posted From: 204.17.116.130

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 1:08 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:

ledu baa.. nee kashtanni choosi badhatho cheptunna



Gochi kustanni namme manishi, ammukune manishi kadhu...
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Celebrity Bewarse
Username: Onlymovies

Post Number: 8898
Registered: 01-2009
Posted From: 199.173.224.32

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 1:05 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

punch aaa

ledu baa.. nee kashtanni choosi badhatho cheptunna
Sachin is the highest individual scorer in ODI.
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 67001
Registered: 07-2004
Posted From: 148.168.127.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 1:04 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:

andaroo neela kashta padalerukada baa..



punch aaa

Top of pagePrevious messageNext messageBottom of page Link to this message

Nitho
Celebrity Bewarse
Username: Nitho

Post Number: 7515
Registered: 12-2004
Posted From: 204.17.116.130

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 1:01 pm:    Edit Post Delete Post View Post/Check IP
Fubar:

telvakaa adigaam ley voo



naku edhuko neeku kuda SQL vachu ani chupinchu kuntunnavemo ani doubt ga undhi..

prathi saro adugutav, malli nuvve modify chesi vachindhi le annatav... ee vanni chustunte doubt
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Celebrity Bewarse
Username: Onlymovies

Post Number: 8897
Registered: 01-2009
Posted From: 199.173.224.32

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 1:00 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

asalu sagam work DB volla setha sepinchesthunnaavgaa hemesh....ikkada BTDB lo oka kochen,PFDB lo okati,CCDB lo okati ilaa project manager lekka nee tasks ani janaalaki distributing chesthunnaavani colorado side correst info

andaroo neela kashta padalerukada baa..
Sachin is the highest individual scorer in ODI.
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 66997
Registered: 07-2004
Posted From: 148.168.127.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 12:57 pm:    Edit Post Delete Post View Post/Check IP
asalu sagam work DB volla setha sepinchesthunnaavgaa hemesh....ikkada BTDB lo oka kochen,PFDB lo okati,CCDB lo okati ilaa project manager lekka nee tasks ani janaalaki distributing chesthunnaavani colorado side correst info

Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 66996
Registered: 07-2004
Posted From: 148.168.127.10

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 12:55 pm:    Edit Post Delete Post View Post/Check IP
Nitho:

first

Delete * from xxhr_employee_coa
then
Update
oo pani ayyi poddi



Top of pagePrevious messageNext messageBottom of page Link to this message

Fubar
Yavvanam Kaatesina Bewarse
Username: Fubar

Post Number: 1176
Registered: 11-2006
Posted From: 192.44.136.113

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 12:38 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

financials ayithe coding seyyara endi..edo employees migration sethunna..so coding chesthunna daniki




telvakaa adigaam ley voo
B L A H
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12844
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 12:18 pm:    Edit Post Delete Post View Post/Check IP
Nitho:

emi chesav emi avvuthundi..



Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12843
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 12:18 pm:    Edit Post Delete Post View Post/Check IP
Fubar:

pills ga nuvvu oracle developer vaa, I thought u were oracle financials guy



financials ayithe coding seyyara endi..edo employees migration sethunna..so coding chesthunna daniki
Top of pagePrevious messageNext messageBottom of page Link to this message

Fubar
Yavvanam Kaatesina Bewarse
Username: Fubar

Post Number: 1175
Registered: 11-2006
Posted From: 192.44.136.113

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 12:10 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



pills ga nuvvu oracle developer vaa, I thought u were oracle financials guy
B L A H
Top of pagePrevious messageNext messageBottom of page Link to this message

Nitho
Celebrity Bewarse
Username: Nitho

Post Number: 7511
Registered: 12-2004
Posted From: 204.17.116.130

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:46 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

ade chesa ippudu. work avuthundi



emi chesav emi avvuthundi..
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12842
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:43 am:    Edit Post Delete Post View Post/Check IP
ya 420 annai...ade chesa ippudu. :-) work avuthundi :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

420
Celebrity Bewarse
Username: 420

Post Number: 9346
Registered: 12-2006
Posted From: 212.159.240.81

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:42 am:    Edit Post Delete Post View Post/Check IP
Hemu bedar .. in Oracle ? use the following sytax .. where Clause in Update statement ..

UPDATE <table_name>
SET <column_name> = (
SELECT <column_name>
FROM <table_name
WHERE <column_name> <condition> <value>)
WHERE <column_name> <condition> <value>;
Knit India,do not split India !
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12841
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:42 am:    Edit Post Delete Post View Post/Check IP
idi correct query...hehe...2006 rows update chesthundi ippudu...


update xxhr_i188_employee_stg es
set (es.financial_entity,
es.cost_center,
es.product_line,
es.mrkt_segment) = ( select ec.financial_entity,
ec.cost_center,
ec.r12_product_line,
ec.r12_mrkt_segment
from xxhr_employee_coa ec
where ec.bems_id = es.bems_id
and ec.first_name= es.first_name
and ec.last_name= es.last_name)
where 1 = 1
and exists (
select 'x'
from xxhr_employee_coa ec
where ec.bems_id = es.bems_id
and ec.first_name= es.first_name
and ec.last_name= es.last_name
)
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12840
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:40 am:    Edit Post Delete Post View Post/Check IP
ila marchanu query ni...correct ee naa...


update xxhr_i188_employee_stg es
set (es.financial_entity,
es.cost_center,
es.product_line,
es.mrkt_segment) = ( select ec.financial_entity,
ec.cost_center,
ec.r12_product_line,
ec.r12_mrkt_segment
from xxhr_employee_coa ec
where ec.bems_id = es.bems_id
and ec.first_name= es.first_name
and ec.last_name= es.last_name)
where 1 = 1
and exists (
select 'x'
from xxhr_employee_coa ec
where ec.bems_id = es.bems_id
)
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12839
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:38 am:    Edit Post Delete Post View Post/Check IP
Nitho:

first

Delete * from xxhr_employee_coa

then

Update

oo pani ayyi poddi



Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12838
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:37 am:    Edit Post Delete Post View Post/Check IP
Fubar:



Top of pagePrevious messageNext messageBottom of page Link to this message

Nitho
Celebrity Bewarse
Username: Nitho

Post Number: 7510
Registered: 12-2004
Posted From: 204.17.116.130

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:36 am:    Edit Post Delete Post View Post/Check IP
first

Delete * from xxhr_employee_coa

then

Update

oo pani ayyi poddi
Top of pagePrevious messageNext messageBottom of page Link to this message

Fubar
Yavvanam Kaatesina Bewarse
Username: Fubar

Post Number: 1174
Registered: 11-2006
Posted From: 192.44.136.113

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:36 am:    Edit Post Delete Post View Post/Check IP
B L A H
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12837
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:35 am:    Edit Post Delete Post View Post/Check IP
es table lo around 3000 rows unnay..kani ec table lo 2009 unnay..ee update rasthe 3000 rows updated ani vasthundi..rollback chesanu...emanna thappu unda ee query lo. either 2009 or less rows ee update avvali ga.
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 12836
Registered: 06-2004
Posted From: 169.143.0.103

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, March 10, 2010 - 11:35 am:    Edit Post Delete Post View Post/Check IP
update xxhr_i188_employee_stg es
set (es.financial_entity,
es.cost_center,
es.product_line,
es.mrkt_segment) = ( select ec.financial_entity,
ec.cost_center,
ec.r12_product_line,
ec.r12_mrkt_segment
from xxhr_employee_coa ec
where ec.bems_id = es.bems_id
and ec.first_name= es.first_name
and ec.last_name= es.last_name)

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration