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 August 09, 2011 * SQL Query Help < Previous Next >

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

Stewie
Pilla Bewarse
Username: Stewie

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

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

Posted on Monday, August 08, 2011 - 12:02 pm:    Edit Post Delete Post View Post/Check IP
Onlyniru3:

483860 recs raavali..? mari final ga out put enti 55840668



outer joins cheste peruguthai kada just join cheyyi ..
kothga petta signature ela undi CLIPART--new
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13386
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 10:33 am:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:



bedar .. what is you desired slut i mean result.?..



13381 post lo explain chesaanu choodandi annai... driving table lo some 483860 records vunnayi.... Left outer join anthe driving table lo vunna anni recs raavali kadha. so max 483860 recs raavali..? mari final ga out put enti 55840668 records vachaayi? AM i doing anything wrong in the QueryMOVIEART--bemmi.adi
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13385
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 10:30 am:    Edit Post Delete Post View Post/Check IP
bemmam annai idhigo ee thed choodu.... inko 4 DB's lo vesi naaku answer pattukoni raava?MOVIEART--ali
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Celebrity Bewarse
Username: Penkonda_tiger

Post Number: 5580
Registered: 06-2005
Posted From: 62.12.14.26

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

Posted on Monday, August 08, 2011 - 10:30 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:

Rakarakaluga kasta padi Joins meedha oka Query raasanu... Idhi correcte nemo choodadndi annai's....



bedar .. what is you desired slut i mean result.?..
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13384
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 10:30 am:    Edit Post Delete Post View Post/Check IP
Kritunga:



rey pundu meedha kaaram sallaka....MOVIEART--bemmi.sarasam
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13383
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 10:29 am:    Edit Post Delete Post View Post/Check IP
Sachinfan:

MOVIEART--bemmi.sarasam
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13381
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 10:24 am:    Edit Post Delete Post View Post/Check IP
SELECT COUNT(*)
FROM
(SELECT time_id,
kpis_day_value,
kpis_name,
e.parnt_acct_id
FROM
(SELECT dr.account_dim_key,
dr.time_id,
dr.kpis_day_value,
kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= 20110718 AND dr.time_id < 20110719 AND kpisms.active_indicator = 'YES') c
LEFT OUTER JOIN
ids_admin.admin.account_dim d
ON c.account_dim_key = d.account_dim_key
LEFT OUTER JOIN
edw_admin.admin.vw_edw_tda_acct_tos_acct_rel e
ON d.account_identifier = e.child_acct_id
WHERE e.parnt_acct_id > -1 AND e.child_acct_id > -1) f

Is giving 483860 records. The logic is working correct up to now.

After doing LEFT OUTER JOIN ON ids_admin.admin.account_dim to get the matching business_unit_code of the parent_acct_nbr we are getting count
55840668 records. Which is wrong. It is expected to give the same 483860 records as the output.

SELECT COUNT(*)
FROM
(SELECT time_id,
kpis_day_value,
kpis_name,
e.parnt_acct_id
FROM
(SELECT dr.account_dim_key,
dr.time_id,
dr.kpis_day_value,
kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= 20110718 AND dr.time_id < 20110719 AND kpisms.active_indicator = 'YES') c
LEFT OUTER JOIN
ids_admin.admin.account_dim d
ON c.account_dim_key = d.account_dim_key
LEFT OUTER JOIN
edw_admin.admin.vw_edw_tda_acct_tos_acct_rel e
ON d.account_identifier = e.child_acct_id
WHERE e.parnt_acct_id > -1 AND e.child_acct_id > -1) f
LEFT OUTER JOIN
ids_admin.admin.account_dim g
ON f.parnt_acct_id = g.account_identifier
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Kritunga
Yavvanam Kaatesina Bewarse
Username: Kritunga

Post Number: 1323
Registered: 07-2011
Posted From: 183.82.156.124

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

Posted on Monday, August 08, 2011 - 10:24 am:    Edit Post Delete Post View Post/Check IP
daridram vadilindi
You-know-who
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13380
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 10:24 am:    Edit Post Delete Post View Post/Check IP
denemme ee query sarigga pani cheyatam ledhu..MOVIEART--mummyeggiri tannindhi.....
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachinfan
Bewarse Legend
Username: Sachinfan

Post Number: 18863
Registered: 10-2010
Posted From: 66.151.103.9

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

Posted on Monday, August 08, 2011 - 9:49 am:    Edit Post Delete Post View Post/Check IP
neeku dandam edata.. gurthu seyamaaka baava..MOVIEART--mummy
gaali puraanam...sollu ki ankitham CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13379
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 9:31 am:    Edit Post Delete Post View Post/Check IP
Sachinfan:

bava antha maata antava.. urgent ga sql nerchukovali ite nenu..



bava... Shell scripting entha varaku vachindhi.. Oka requirement vundhi choostava?MOVIEART--raaja
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachinfan
Bewarse Legend
Username: Sachinfan

Post Number: 18850
Registered: 10-2010
Posted From: 66.151.103.9

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

Posted on Monday, August 08, 2011 - 9:29 am:    Edit Post Delete Post View Post/Check IP
bava antha maata antava.. urgent ga sql nerchukovali ite nenu..MOVIEART--venky
gaali puraanam...sollu ki ankitham CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13378
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 9:29 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:

baaava...



denemma mummy icon place lo deyyam icon vachindhi enti... place lu marchakandi ehe....
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13377
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 9:28 am:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:



Annai komcham correcte nemo choodanadi.. ee DB lo meeru Stewie and balli baa's ee maaku dikku ee SQL queries meedha....MOVIEART--dv.cry
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13376
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 9:27 am:    Edit Post Delete Post View Post/Check IP
Sachinfan:

wrong



baaava...MOVIEART--deyyam
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Celebrity Bewarse
Username: Penkonda_tiger

Post Number: 5573
Registered: 06-2005
Posted From: 62.12.14.26

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

Posted on Monday, August 08, 2011 - 9:18 am:    Edit Post Delete Post View Post/Check IP
Sachinfan:

wrong



SPrite
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachinfan
Bewarse Legend
Username: Sachinfan

Post Number: 18847
Registered: 10-2010
Posted From: 66.151.103.9

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

Posted on Monday, August 08, 2011 - 9:17 am:    Edit Post Delete Post View Post/Check IP
wrongMOVIEART--bwalk
gaali puraanam...sollu ki ankitham CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13375
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Monday, August 08, 2011 - 9:15 am:    Edit Post Delete Post View Post/Check IP
Rakarakaluga kasta padi Joins meedha oka Query raasanu... Idhi correcte nemo choodadndi annai's....


select c.time_id,c.kpis_day_value,c.kpis_name,e.parnt_acct_id,f.active_business_unit_co de from
(SELECT dr.account_dim_key,dr.time_id,dr.kpis_day_value,kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= 20110718 AND
dr.time_id < 20110719 AND
kpisms.active_indicator = 'YES'
)c
LEFT OUTER JOIN
ids_admin.admin.account_dim d
ON c.account_dim_key = d.account_dim_key
LEFT OUTER JOIN
edw_admin.admin.vw_edw_tda_acct_tos_acct_rel e
ON d.account_identifier = e.child_acct_id
LEFT OUTER JOIN
ids_admin.admin.account_dim f
ON e.parnt_acct_id = f.account_identifier
WHERE
e.parnt_acct_id > -1 AND e.child_acct_id > -1
ORDER BY
c.time_id,e.parnt_acct_id
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Mudiripoyina Bewarse
Username: Vja

Post Number: 3228
Registered: 12-2009
Posted From: 24.96.59.144

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

Posted on Saturday, August 06, 2011 - 9:01 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:

MOVIEART--bemmi.adi
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13346
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 4:27 am:    Edit Post Delete Post View Post/Check IP
Vja:



neeeku oka 'chick'let...MOVIEART--kummesana
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13345
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 4:22 am:    Edit Post Delete Post View Post/Check IP
Blazewada:

let me create sample tables and try.
test data emanna ivvagalavaa? naa PC lo try maduthaa.



anthe inka try chesi cheptaa ani annav kadha ani .. waiting chestini baaa...:-)
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13344
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 4:21 am:    Edit Post Delete Post View Post/Check IP
select c.time_id,c.kpis_day_value,c.kpis_name, d.account_identifier, d.active_business_unit_code from
(SELECT dr.account_dim_key,dr.time_id,dr.kpis_day_value,kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= 20110718 AND
dr.time_id < 20110719 AND
kpisms.active_indicator = 'YES'
ORDER BY dr.account_dim_key,dr.time_id)c
LEFT OUTER JOIN
account_dim d
ON
c.account_dim_key = d.account_dim_key
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Bewarse Legend
Username: Blazewada

Post Number: 17321
Registered: 08-2008
Posted From: 202.156.10.227

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

Posted on Saturday, August 06, 2011 - 4:21 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:



nenu septi baa, naa post soodaledaa.. MOVIEART--mummy

../5/23898.html"../../clipart/smoke.gif" border=0 alt="CLIPART--smoke">
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Mudiripoyina Bewarse
Username: Vja

Post Number: 3226
Registered: 12-2009
Posted From: 24.96.59.144

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

Posted on Saturday, August 06, 2011 - 4:19 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:

work ayyindhi.

MOVIEART--naakenti
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13343
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 4:19 am:    Edit Post Delete Post View Post/Check IP
Stewie:

Select * from (....) Test 1,(...) 2Nd query where...nee join condition


Ante basically table perla badulu nee queries pedite raada?



manam full weeku baaa SQL lo... ee kitukulu anni telieevu..... :-(
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13342
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 4:19 am:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:



Thanks annai meeru icchindhi work ayyindhi....:-)
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Celebrity Bewarse
Username: Penkonda_tiger

Post Number: 5438
Registered: 06-2005
Posted From: 82.157.134.169

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

Posted on Saturday, August 06, 2011 - 4:17 am:    Edit Post Delete Post View Post/Check IP
Stewie:

Ante basically table perla badulu nee queries pedite raada?




Eggzactly .. thats also my rammble ..

MOVIEART--bwalk
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Mudiripoyina Bewarse
Username: Vja

Post Number: 3225
Registered: 12-2009
Posted From: 24.96.59.144

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

Posted on Saturday, August 06, 2011 - 4:17 am:    Edit Post Delete Post View Post/Check IP
Prasanth:

taagina roju nidra pattadhu



dry ayiddi annai naalika.. kontha mandiki nidra fattadu andukani
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Prasanth
Bewarse Legend
Username: Prasanth

Post Number: 60084
Registered: 03-2004
Posted From: 110.76.160.100

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

Posted on Saturday, August 06, 2011 - 4:16 am:    Edit Post Delete Post View Post/Check IP
taagina roju nidra pattadhu..endho kondaru taaga gaane tonguntaaru
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Mudiripoyina Bewarse
Username: Vja

Post Number: 3223
Registered: 12-2009
Posted From: 24.96.59.144

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

Posted on Saturday, August 06, 2011 - 4:16 am:    Edit Post Delete Post View Post/Check IP
Stewie:

rathri taagindaaniki poddunne melku ochindi naaku



manaki saripoka nidra fattaledii MOVIEART--avs
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 441
Registered: 03-2011
Posted From: 24.147.86.254

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

Posted on Saturday, August 06, 2011 - 4:15 am:    Edit Post Delete Post View Post/Check IP
Vja:

endayya em peeking....rathri taagindaaniki poddunne melku ochindi naaku.nidra patti saavatle
kothga petta signature ela undi CLIPART--new
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Mudiripoyina Bewarse
Username: Vja

Post Number: 3221
Registered: 12-2009
Posted From: 24.96.59.144

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

Posted on Saturday, August 06, 2011 - 4:13 am:    Edit Post Delete Post View Post/Check IP
Stewie:

MOVIEART--bemmi.dance
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 440
Registered: 03-2011
Posted From: 24.147.86.254

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

Posted on Saturday, August 06, 2011 - 4:12 am:    Edit Post Delete Post View Post/Check IP
Select * from (....) Test 1,(...) 2Nd query where...nee join condition


Ante basically table perla badulu nee queries pedite raada?
kothga petta signature ela undi CLIPART--new
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Celebrity Bewarse
Username: Penkonda_tiger

Post Number: 5436
Registered: 06-2005
Posted From: 82.157.134.169

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

Posted on Saturday, August 06, 2011 - 4:08 am:    Edit Post Delete Post View Post/Check IP
ON3 bedar .. whats so complication in the ?

Select test1.* , ACCOUNT_DIM.account_identifier, ACCOUNT_DIM.active_business_unit_cod from
((((SELECT dr.account_dim_key,dr.time_id,dr.kpis_day_value,kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= 20110718 AND
dr.time_id < 20110719 AND
kpisms.active_indicator = 'YES'
ORDER BY dr.account_dim_key))))) TEST1 ,ACCOUNT_DIM
where
TEST1.account_dim_key = ACCOUNT_DIM.account_dim_key
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13335
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 3:52 am:    Edit Post Delete Post View Post/Check IP
Vja:

inkaa left oter right outer vadutunnaaara saaavi



Mari ela Vija baa.. ala kakunda emanna vaada vacha?
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Mudiripoyina Bewarse
Username: Vja

Post Number: 3210
Registered: 12-2009
Posted From: 24.96.59.144

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

Posted on Saturday, August 06, 2011 - 3:51 am:    Edit Post Delete Post View Post/Check IP
inkaa left oter right outer vadutunnaaara saaavi MOVIEART--avs
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13332
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 3:41 am:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:

bedar can you vivarimpuudee with a clear example and table names



((((SELECT dr.account_dim_key,dr.time_id,dr.kpis_day_value,kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= 20110718 AND
dr.time_id < 20110719 AND
kpisms.active_indicator = 'YES'
ORDER BY dr.account_dim_key))))) TEST1


The ouput of this Query is
account_dim_key ,time_id, kpis_day_value, kpis_name
100719801, 20110718, 20.0000, TOTAL_ASSET_BAL
100719801, 20110718, 20.0000, TOTAL_MARGIN_BAL
100941824, 20110718, 500.0000, ASSETS_IN_TOTAL
100941824, 20110718, 500.0000, ASSETS_NET_NEW


Data in ACCOUNT_DIM

account_dim_key, account_identifier, active_business_unit_code
100941824, 1006006253, 100
100719801, 1005257828, 100


So Now I need to left outer Join TEST1 and ACCOUNT_DIM based up on join condition test1.account_dim_key = account_dim.account_dim_key.
(all recs from TEST1 and matching recs from ACCOUNT_DIM)


Output should be like

time_id, kpis_day_value, kpis_name, account_identifier , active_business_unit_code,
20110718, 20.0000, TOTAL_ASSET_BAL , 1005257828 , 100
20110718 , 20.0000, TOTAL_MARGIN_BAL, 1005257828, 100
20110718, 500.0000, ASSETS_IN_TOTAL, 1006006253, 100
20110718, 500.0000, ASSETS_NET_NEW, 1006006253, 100
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Celebrity Bewarse
Username: Penkonda_tiger

Post Number: 5429
Registered: 06-2005
Posted From: 82.157.134.169

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

Posted on Saturday, August 06, 2011 - 3:12 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:

E query nunchi vache output tho ACCOUNT_DIM ane table meedha Join chesi account_identifier, active_business_unit_code from ACCOUNT_DIM table nunchi teesukuraavali.... Join condition dr.account_dim_key = account_dim.account_di_key. Left outer jouin cheyali.. all the recs should come from query in braces and matching recs shuld come from ACCOUNT_DIM table.. ELa raayali Query?




bedar can you vivarimpuudee with a clear example and table names
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Bewarse Legend
Username: Blazewada

Post Number: 17320
Registered: 08-2008
Posted From: 202.156.10.227

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

Posted on Saturday, August 06, 2011 - 3:00 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:



ee query output ni oka table kinda define cheyy like

((((SELECT dr.account_dim_key,dr.time_id,dr.kpis_day_value,kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= 20110718 AND
dr.time_id < 20110719 AND
kpisms.active_indicator = 'YES'
ORDER BY dr.account_dim_key))))) TEST_DIM

and nee ACCOUNT_DIM table tho Outer oin chese autundemo? let me create sample tables and try.
test data emanna ivvagalavaa? naa PC lo try maduthaa.
Mind lo Fix Aithey Blind gaa ellipotaa...CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Mudiripoyina Bewarse
Username: Vja

Post Number: 3198
Registered: 12-2009
Posted From: 24.96.59.144

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

Posted on Saturday, August 06, 2011 - 3:00 am:    Edit Post Delete Post View Post/Check IP
MOVIEART--dobbeyi
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13331
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 2:46 am:    Edit Post Delete Post View Post/Check IP
Komcham urgetnt.. dont play jokes uzeless. S/W engineers anthe andariki lokuve...
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
Top of pagePrevious messageNext messageBottom of page Link to this message

Kritunga
Yavvanam Kaatesina Bewarse
Username: Kritunga

Post Number: 1044
Registered: 07-2011
Posted From: 183.82.156.124

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

Posted on Saturday, August 06, 2011 - 2:41 am:    Edit Post Delete Post View Post/Check IP
2nd line and 4th line interchange chesi 5th line ni sagam edit cheyyi...all set
You-know-who
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13330
Registered: 08-2009
Posted From: 216.105.250.4

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

Posted on Saturday, August 06, 2011 - 2:37 am:    Edit Post Delete Post View Post/Check IP
((((SELECT dr.account_dim_key,dr.time_id,dr.kpis_day_value,kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= 20110718 AND
dr.time_id < 20110719 AND
kpisms.active_indicator = 'YES'
ORDER BY dr.account_dim_key)))))


E query nunchi vache output tho ACCOUNT_DIM ane table meedha Join chesi account_identifier, active_business_unit_code from ACCOUNT_DIM table nunchi teesukuraavali.... Join condition dr.account_dim_key = account_dim.account_di_key. Left outer jouin cheyali.. all the recs should come from query in braces and matching recs shuld come from ACCOUNT_DIM table.. ELa raayali Query?
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu

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