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 - 2011 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through July 06, 2011 * SQL Help < Previous Next >

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

Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey

Post Number: 1546
Registered: 03-2011
Posted From: 136.174.187.5

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

Posted on Thursday, June 30, 2011 - 1:22 pm:    Edit Post Delete Post View Post/Check IP
Stewie:

btw ninna aa API di ochindi ivala .. copy paste chesa verey package ninchi..



adendi mari ekkada tannindantaaaav ninna MOVIEART--avataram
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 199
Registered: 03-2011
Posted From: 63.138.168.7

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

Posted on Thursday, June 30, 2011 - 1:17 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

btw ninna aa API di ochindi ivala .. copy paste chesa verey package ninchi..
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 198
Registered: 03-2011
Posted From: 63.138.168.7

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

Posted on Thursday, June 30, 2011 - 1:15 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

MOVIEART--raaja saddukopovalamma.. cinna hint iste..
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey

Post Number: 1542
Registered: 03-2011
Posted From: 136.174.187.5

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

Posted on Thursday, June 30, 2011 - 1:09 pm:    Edit Post Delete Post View Post/Check IP
Stewie:

nen rasindi ade anukunta


madyalo null yaada nunchi vachindii
MOVIEART--normuy
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 197
Registered: 03-2011
Posted From: 63.138.168.7

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

Posted on Thursday, June 30, 2011 - 1:06 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

nen rasindi ade anukunta :MOVIEART--bemmi.angry
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey

Post Number: 1538
Registered: 03-2011
Posted From: 136.174.187.5

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

Posted on Thursday, June 30, 2011 - 12:59 pm:    Edit Post Delete Post View Post/Check IP
Stylestar:


anthe baaa correstee .. thankss

vachinatte undi
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1851
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 12:59 pm:    Edit Post Delete Post View Post/Check IP
Sachinfan:

enti kotta series start cheste asalu participation ee lekunda poindi



nuvvu hyd bull kummuthunaruga.. inka naa participation endhukuani..MOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1850
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 12:58 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

table lo entity_name po_headers ayithe.. po_headers_all table exists condition

fa_additions ayithe fa_additions_v exists condition kosam choodali



baa nee q. sariga ardhamu avaledhu.. but my understanding kindha ex. chudu

where
(
(
entity_name = 'PO_HEADERS'
and
exists (select 'x' from po_headers_all where...)
)
OR
(
entity_name = 'FA_ADDITIONS'
and
exists (select 'x' from fa_additions_vwhere...)
)
)
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachinfan
Bewarse Legend
Username: Sachinfan

Post Number: 16005
Registered: 10-2010
Posted From: 66.151.103.8

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

Posted on Thursday, June 30, 2011 - 12:52 pm:    Edit Post Delete Post View Post/Check IP
Stylestar:

enti kotta series start cheste asalu participation ee lekunda poindi..MOVIEART--bemmi.angry
Pulihara kaburlu... pani paata leka CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1849
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 12:49 pm:    Edit Post Delete Post View Post/Check IP
Sachinfan:

how are ya



I am doing fine baa.. CLIPART--highfive
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey

Post Number: 1528
Registered: 03-2011
Posted From: 136.174.187.5

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

Posted on Thursday, June 30, 2011 - 12:48 pm:    Edit Post Delete Post View Post/Check IP
Stewie:

and (

(exists ( query) and po_header is null )
or (exists (query) and fa_Additions is null)

)



avi null undavuu..

table lo entity_name po_headers ayithe.. po_headers_all table exists condition

fa_additions ayithe fa_additions_v exists condition kosam choodali
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachinfan
Bewarse Legend
Username: Sachinfan

Post Number: 16000
Registered: 10-2010
Posted From: 66.151.103.8

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

Posted on Thursday, June 30, 2011 - 12:46 pm:    Edit Post Delete Post View Post/Check IP
Stylestar:

yoo banni baa.. edo busy ga vundav ani idakati nunchi eduru suttanda.. epud ipotada ani..

how are ya..MOVIEART--hello
Pulihara kaburlu... pani paata leka CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 16004
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 12:45 pm:    Edit Post Delete Post View Post/Check IP
Stylestar:

malli eppud dharsanam.. MOVIEART--bemmi.sarle



malla edanna help kavalsi vasthe baa..MOVIEART--ali
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1848
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 12:42 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



malli eppud dharsanam.. MOVIEART--bemmi.sarle
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 16002
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 12:35 pm:    Edit Post Delete Post View Post/Check IP
Stewie:



baa stylestar query simple ga undi ani adi vadesa..adi koda work avuthundi baa.needi koda work ayyindi MOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 196
Registered: 03-2011
Posted From: 63.138.168.7

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

Posted on Thursday, June 30, 2011 - 12:26 pm:    Edit Post Delete Post View Post/Check IP
Stylestar:

ok baa.. vamo nuvvu tables create chesi maree test chestunaava



abaandam esav naa meda MOVIEART--dv
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1847
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 12:25 pm:    Edit Post Delete Post View Post/Check IP
Stewie:



ok baa.. vamo nuvvu tables create chesi maree test chestunaava. MOVIEART--bemmi.gm
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 195
Registered: 03-2011
Posted From: 63.138.168.7

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

Posted on Thursday, June 30, 2011 - 12:21 pm:    Edit Post Delete Post View Post/Check IP
Stylestar:

baa.. ippudu same count undi different serial numbers unte idhi fail avuthundhi.

for example table 3

4 1234
4 2345
4 4567



ledu ba avvadu endukante.. match ayyina vative count teesukuntam.. manam.. match avvadu ga 4567 so aa number assalu inner loop lo radu try chesa ippude ne test case :P
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 194
Registered: 03-2011
Posted From: 63.138.168.7

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

Posted on Thursday, June 30, 2011 - 12:17 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

s it possible to use EXISTS condition based on decode function??

entity_name column undii.. danlo PO_HEADERS,FA_ADITIONS_V values untay....

PO_HEADERS unnapudu oka EXISTS condition
FA_ADDITIONS_V unnapudu inko EXISTS condition use cheskovaali query

howww?




and (

(exists ( query) and po_header is null )
or (exists (query) and fa_Additions is null)

)


ila rayacha ?
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1846
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 12:14 pm:    Edit Post Delete Post View Post/Check IP
Stewie:

apple.cnt = mango.cnt



baa.. ippudu same count undi different serial numbers unte idhi fail avuthundhi.

for example table 3

4 1234
4 2345
4 4567
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 16001
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 11:45 am:    Edit Post Delete Post View Post/Check IP
select 'x' from dual
where not exists (
select 'x'
from table1 tbl1
where tbl1.header_id = :varhdr1
and tbl1.line_id = :varline1
and NOT exists
(select 'x'
from table2 tbl2, table3 tbl3
where tbl2.header_id = tbl1.header_id
and tbl2.line_id = tbl1.line_id
and tbl3.deliver_id = tbl2.deliver_id
and tbl3.serial_number = tbl1.serial_number) )
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 16000
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 11:44 am:    Edit Post Delete Post View Post/Check IP
Stylestar:



yes..work ayyindi..MOVIEART--ali

help chesina andariki naa vandanalu CLIPART--hug1
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15999
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 11:42 am:    Edit Post Delete Post View Post/Check IP
Stylestar:

baa.. adhe kadha cheppedhi.. if no rows returned then it is condition return 1 (all rows match). If rows returned then it is oondition return 0 (no matching rows)

reverse lo alochinchu baa.



got it bhayya..test chesa..that works..kani nenu vere select lo where condition lo idi pettali..so not exists ani pettesi nee query pedithe when no rows returns means..all are matched ane kada bhayya?
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15998
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 11:38 am:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:

select * from (select Table2.header_Id,table2.line_id,table3.deliver_id,table3.serial_number
from
Table2,Table3 where Table2.deliver_id = Table3.deliver_id )Temp ,
Table1
where
Temp.header_Id = Table1.header_Id
and
Temp.serial_number = Table1.serial_number


bedar .. this might work or the Cartesian product strategy will work .. otherwise .. will help u when byaak at home in 3 hours .. this KC is waiting on the ground floor ..



idi work avvaledu bhayya..match ayina 3 rows data ni thechindi..1st table lo extra ga oka row petta..that serial_number doesn't exists in the 3rd table..so it fetched the matched records..
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1845
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 11:37 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

as it retuns no rows eventhough all the 3 serial numbers exists in the 3rd table..



baa.. adhe kadha cheppedhi.. if no rows returned then it is condition return 1 (all rows match). If rows returned then it is oondition return 0 (no matching rows)

reverse lo alochinchu baa.
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15997
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 11:34 am:    Edit Post Delete Post View Post/Check IP
Stewie:



bhayya..your query is working..inka assala table names pettesi kummestha..ee test data ki 3 tables create chesi same data petta..and extra row okati petta 1st table lo..aa serial number 3rd table lo ledu..perfect ga work ayyindi..kummesav bhayya..thanks so much...
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15996
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 11:31 am:    Edit Post Delete Post View Post/Check IP
Stylestar:


select '0'
from table1 tbl1
where tbl1.header_id = :varhdr1
and tbl1.line_id = :varline1
and NOT exists
(select 'x'
from table2 tbl2, table3 tbl3
where tbl2.header_id = tbl1.header_id
and tbl2.line_id = tbl1.line_id
and tbl3.deliver_id = tbl2.deliver_id
and tbl3.serial_number = tbl1.serial_number)



this is not working..as it retuns no rows eventhough all the 3 serial numbers exists in the 3rd table..

the above query find all the 3 serial_number s in the 3rd table so the not exists conditions fails
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1844
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 11:23 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



select '0'
from table1 tbl1
where tbl1.header_id = :varhdr1
and tbl1.line_id = :varline1
and NOT exists
(select 'x'
from table2 tbl2, table3 tbl3
where tbl2.header_id = tbl1.header_id
and tbl2.line_id = tbl1.line_id
and tbl3.deliver_id = tbl2.deliver_id
and tbl3.serial_number = tbl1.serial_number)

this gives return 0
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15995
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 11:21 am:    Edit Post Delete Post View Post/Check IP
Stylestar:



ee 2nd query bhayya?
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1843
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 11:17 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

for the given header_id and line_id in table1..there might be multiple rows with the same header_id and line_id and different serial_numbers..we need to check if all the serial_numbers exists in table3..If any one is missing from table3..then return 0.if all exists return 1



alatappudu the second query work avvaali kadha..
the query returns value if there are no serial number matching with table3 for a give header id and line id.

aa query value return cheyyaledhante anni serial numbers unnatlue..

reverse lo finding..
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey

Post Number: 1527
Registered: 03-2011
Posted From: 136.174.187.5

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

Posted on Thursday, June 30, 2011 - 11:07 am:    Edit Post Delete Post View Post/Check IP
MOVIEART--avataram
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey

Post Number: 1526
Registered: 03-2011
Posted From: 136.174.187.5

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

Posted on Thursday, June 30, 2011 - 10:44 am:    Edit Post Delete Post View Post/Check IP
is it possible to use EXISTS condition based on decode function??

entity_name column undii.. danlo PO_HEADERS,FA_ADITIONS_V values untay....

PO_HEADERS unnapudu oka EXISTS condition
FA_ADDITIONS_V unnapudu inko EXISTS condition use cheskovaali query

howww?
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15994
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 10:39 am:    Edit Post Delete Post View Post/Check IP
Stewie:



MOVIEART--bemmi.ayyo aagu bhayya sootha..sagam chosa..mind thirigindi..
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey

Post Number: 1525
Registered: 03-2011
Posted From: 136.174.187.5

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

Posted on Thursday, June 30, 2011 - 10:38 am:    Edit Post Delete Post View Post/Check IP
Stewie:

alaa rasukuntu poya.. kani pani chesindi ..



nuvv rasthaav babu raasthaavu MOVIEART--blessme
Top of pagePrevious messageNext messageBottom of page Link to this message

Kichidi
Bewarse Legend
Username: Kichidi

Post Number: 20331
Registered: 02-2010
Posted From: 168.244.23.111

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

Posted on Thursday, June 30, 2011 - 10:31 am:    Edit Post Delete Post View Post/Check IP
Gochi:

ivevo facchi boothul lekkunnaayi


count ni cunt sesava.. u boothul lover MOVIEART--raaja
ITALIAN MAFIASOCLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 73634
Registered: 07-2004
Posted From: 70.44.12.183

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

Posted on Thursday, June 30, 2011 - 10:30 am:    Edit Post Delete Post View Post/Check IP
Stewie:

apple.cnt = mango.cnt



ivevo facchi boothul lekkunnaayi

MOVIEART--bemmi.look
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 192
Registered: 03-2011
Posted From: 63.138.168.7

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

Posted on Thursday, June 30, 2011 - 10:14 am:    Edit Post Delete Post View Post/Check IP
alaa rasukuntu poya.. kani pani chesindi ..

mind the stupid aliasing :-)

select distinct gg.header_id from table1 gg, (SELECT apple.header_id
FROM ( SELECT DISTINCT COUNT (serial_number) cnt, header_id
FROM table1
GROUP BY header_id) apple,
( SELECT COUNT (tt.bb) cnt, tt.header_id
FROM (SELECT table1.header_id, asd.bb
FROM table1,
(SELECT table2.header_id,
table2.line_id,
table3.serial_number bb
FROM table2, table3
WHERE table2.deliver_id = table3.deliver_id) asd
WHERE table1.header_id = asd.header_id
AND table1.line_id = asd.line_id
AND table1.serial_number = asd.bb) tt
GROUP BY tt.header_id) mango
WHERE apple.header_id = mango.header_id AND apple.cnt = mango.cnt ) bat
where gg.header_id = bat.header_id
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey

Post Number: 1522
Registered: 03-2011
Posted From: 136.174.187.5

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

Posted on Thursday, June 30, 2011 - 10:08 am:    Edit Post Delete Post View Post/Check IP
Stewie:

is delivery id diffreent for each header id ??

MOVIEART--bemmi.sarle
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15993
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 10:07 am:    Edit Post Delete Post View Post/Check IP
Stewie:

is delivery id diffreent for each header id ??



yes bha..for each header_id and line_id combo..
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 191
Registered: 03-2011
Posted From: 63.138.168.7

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

Posted on Thursday, June 30, 2011 - 10:04 am:    Edit Post Delete Post View Post/Check IP
is delivery id diffreent for each header id ??
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15992
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 9:52 am:    Edit Post Delete Post View Post/Check IP
Stylestar:



bhayya..table1 loni header_id and line_id value already pass chesthunna...at a time okate untay..anni chodanavasaram ledu..so nee query emi chesthundi? ardam kaaledu..

for the given header_id and line_id in table1..there might be multiple rows with the same header_id and line_id and different serial_numbers..we need to check if all the serial_numbers exists in table3..If any one is missing from table3..then return 0.if all exists return 1
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1842
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 9:42 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:


baa. then write a select distinct header_id, line_id from table1

for each row selected call the procedure to do this select. This select satisfies return 0

select '0'
from table1 tbl1
where tbl1.header_id = :varhdr1
and tbl1.line_id = :varline1
and not exists
(select 'x'
from table2 tbl2, table3 tbl3
where tbl2.header_id = tbl1.header_id
and tbl2.line_id = tbl1.line_id
and tbl3.deliver_id = tbl2.deliver_id
and tbl3.serial_number = tbl1.serial_number)
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15991
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 9:36 am:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:



thanks bhayya chostha aagu
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15990
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 9:36 am:    Edit Post Delete Post View Post/Check IP
Stylestar:

PL/SQL code chestunava?



yaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Mudiripoyina Bewarse
Username: Penkonda_tiger

Post Number: 4989
Registered: 06-2005
Posted From: 62.12.14.28

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

Posted on Thursday, June 30, 2011 - 9:28 am:    Edit Post Delete Post View Post/Check IP
select * from (select Table2.header_Id,table2.line_id,table3.deliver_id,table3.serial_number
from
Table2,Table3 where Table2.deliver_id = Table3.deliver_id )Temp ,
Table1
where
Temp.header_Id = Table1.header_Id
and
Temp.serial_number = Table1.serial_number


bedar .. this might work or the Cartesian product strategy will work .. otherwise .. will help u when byaak at home in 3 hours .. this KC is waiting on the ground floor .. ..
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1841
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 9:27 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



PL/SQL code chestunava?
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15989
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 9:18 am:    Edit Post Delete Post View Post/Check IP
Stylestar:

table ela define chesaro cheppu..
hdr and line ids?
serial num - Products?
deliver id - deliver status?



vadatam ledu..serial_numbers are different..
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1840
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 9:15 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

vadochu..vadakapovachu..



correct ga theliyali ba.. normalization correct ga ledhu.. requirement prakaram cheppu..

table ela define chesaro cheppu..
hdr and line ids?
serial num - Products?
deliver id - deliver status?
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15988
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 9:12 am:    Edit Post Delete Post View Post/Check IP
Stylestar:

can same serial number be used for different deliver ids?



vadochu..vadakapovachu..kani vadatam ledu anukunta bhayya..
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1839
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 30, 2011 - 9:09 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



can same serial number be used for different deliver ids?
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15987
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 9:06 am:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:

header_id line_id deliver_id

9223 1 4



2nd table lo oka row nee..which gives the delivery_id for header_id and line_id..

header_id line_id deliver_id

9223 1 4
Top of pagePrevious messageNext messageBottom of page Link to this message

Suyodhana
Yavvanam Kaatesina Bewarse
Username: Suyodhana

Post Number: 1764
Registered: 06-2007
Posted From: 117.195.150.99

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

Posted on Thursday, June 30, 2011 - 8:56 am:    Edit Post Delete Post View Post/Check IP
Lilliput:


MOVIEART--bemmi.lol5 eeeyy peda sowdri garini kindal chestava. aligi velte evadu testaadu enakki
Top of pagePrevious messageNext messageBottom of page Link to this message

Bramhanandam
Pilla Bewarse
Username: Bramhanandam

Post Number: 410
Registered: 06-2011
Posted From: 62.12.14.27

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

Posted on Thursday, June 30, 2011 - 8:46 am:    Edit Post Delete Post View Post/Check IP
Lilliput:

edho kochens kaadhu annai SQL (pronounced as Sequel) known as Structured Query Language



Nela thakkuva vedhavaa ani ninnu nani gaadu voorake thittadu raa kothi gaa....
Top of pagePrevious messageNext messageBottom of page Link to this message

Lilliput
Bewarse Legend
Username: Lilliput

Post Number: 10584
Registered: 08-2010
Posted From: 76.185.40.73

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

Posted on Thursday, June 30, 2011 - 8:45 am:    Edit Post Delete Post View Post/Check IP
Bramhanandam:

Vaadedho questions aduguthunte madhaylo neekenti raa noppi

edho kochens kaadhu annai SQL (pronounced as Sequel) known as Structured Query Language MOVIEART--venky.ya
Top of pagePrevious messageNext messageBottom of page Link to this message

Bramhanandam
Pilla Bewarse
Username: Bramhanandam

Post Number: 408
Registered: 06-2011
Posted From: 62.12.14.27

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

Posted on Thursday, June 30, 2011 - 8:44 am:    Edit Post Delete Post View Post/Check IP
Lilliput:

bemmam annai



Vaadedho questions aduguthunte madhaylo neekenti raa noppi MOVIEART--kota.kick....
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15986
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 8:42 am:    Edit Post Delete Post View Post/Check IP
Lilliput:

bemmam annai MOVIEART--bemmi.etakaram



oke roju ki rendu works commit ayyaka..lakkoleka peekkoleka chasthunna..ee SQL query part ayipothe vere work chodali..workflow di..MOVIEART--bemmi.abba
Top of pagePrevious messageNext messageBottom of page Link to this message

Pokiri1
Bewarse Legend
Username: Pokiri1

Post Number: 16983
Registered: 03-2006
Posted From: 192.91.173.36

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

Posted on Thursday, June 30, 2011 - 8:41 am:    Edit Post Delete Post View Post/Check IP
lilli tami bemmam ki help anta cheyyi. alage nee SQL ku imprive avutundi.
ara nimashamulo sachevadivi nee address naku endhuku raa
Top of pagePrevious messageNext messageBottom of page Link to this message

Lilliput
Bewarse Legend
Username: Lilliput

Post Number: 10580
Registered: 08-2010
Posted From: 76.185.40.73

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

Posted on Thursday, June 30, 2011 - 8:40 am:    Edit Post Delete Post View Post/Check IP
bemmam annai MOVIEART--bemmi.etakaram
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15985
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 8:39 am:    Edit Post Delete Post View Post/Check IP
MOVIEART--prayer
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Mudiripoyina Bewarse
Username: Penkonda_tiger

Post Number: 4986
Registered: 06-2005
Posted From: 62.12.14.28

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

Posted on Thursday, June 30, 2011 - 8:27 am:    Edit Post Delete Post View Post/Check IP
MOVIEART--bwalk

waakeee Got it ..
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15984
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, June 30, 2011 - 8:07 am:    Edit Post Delete Post View Post/Check IP
idi requirement..

table1

columns

header_id, line_id, serial_number
9223 1 1234
9223 1 2345
9223 1 3456

---------------

table 2

columns

header_id line_id deliver_id

9223 1 4
9223 1 4
9223 1 4

-------------

table3

columns

deliver_id serial_number
4 1234
4 2345
4 3456

-------------

table1 and table2 ni join chesthe with header_id and line_id, we get the deliver_id from table2 which is in table3. with that delievry+_id in table3, we get a list of serial_numbers in table3. the serial_numbers for that header_id and line_id from table1, all should be in table3. If any one doesn't exists in table3, then we should not return any rows..else return 1.

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