Appice Lo Panem Ledu

[GULABJAM]

nice thread

^G#W Nenu adigindhi em chesav ? 

[pinky123]

^G#W Nenu adigindhi em chesav ? 

chesi isthanu eeroju lopala 

[SUbba LIngam]

edo oka way untundi bhayya..see all tables design and jon them with keys. design emina alter chesi chudataniki neeku option unda??

 

no design changes, only sql changes  

 

fine tuning okkate option kani em cheyaalo emo 

[GULABJAM]

chesi isthanu eeroju lopala 

Nuvventi dp lekunda thiruguthunav ? 

[pinky123]

Nuvventi dp lekunda thiruguthunav ? 

papa vacation ki vellindi 

[GULABJAM]

papa vacation ki vellindi 

Nee nijanga aries ena nuvvu ? 

okasari pm chesuko  

[pinky123]

Nee nijanga aries ena nuvvu ? 

okasari pm chesuko  

its me only pinky--the aries  CITI_c$y  CITI_c$y  CITI_c$y

 

chusanu... eeroju will do  :0012391:

[GULABJAM]

its me only pinky--the aries  CITI_c$y  CITI_c$y  CITI_c$y

 

chusanu... eeroju will do  :0012391:

Hmm Accepted ur GC stamp esa pandaga chesuko 

[pinky123]

Hmm Accepted ur GC stamp esa pandaga chesuko 

 

[Yuvatha]

no design changes, only sql changes  

 

fine tuning okkate option kani em cheyaalo emo 

ok..query chuste emina cheyagalam bhayya....ila gaalilo ante kastame 

[SUbba LIngam]

ok..query chuste emina cheyagalam bhayya....ila gaalilo ante kastame 

 

SELECT DISTINCT s.rowsecclass 

 , a.group_id 

 , g.descr 

 , e.emplid 

 , n.NAME 

  FROM ps_tl_empl_data e 

  , ps_tl_group_dtl a 

  , ps_tl_group_tbl g 

  , ps_names n 

  , ps_tl_grp_security s 

  , psoprdefn o 

 WHERE a.emplid = e.emplid 

   AND n.emplid = e.emplid 

   AND n.name_type = 'PRI' 

   AND n.effdt = ( 

 SELECT MAX (n1.effdt) 

  FROM ps_names n1 

 WHERE n1.emplid = n.emplid 

   AND n1.name_type = 'PRI' 

   AND n1.name_type = n.name_type 

   AND n1.effdt <= SYSDATE) 

   AND a.GROUP_ID = s.GROUP_ID 

   AND a.emplid <> o.emplid 

   AND e.effdt = ( 

 SELECT MAX (e1.effdt) 

  FROM ps_tl_empl_data e1 

 WHERE e1.emplid = e.emplid 

   AND e1.empl_rcd = e.empl_rcd 

   AND e1.effdt <= SYSDATE) 

   AND a.group_id = g.group_id

 

enjoyy bhayya 

 

'psoprdefn' table trouble istundi, andulo key field 'OPRID' kani ee field ee sql lo ekkada use cheyalemu.

[Yuvatha]

 

SELECT DISTINCT s.rowsecclass 

 , a.group_id 

 , g.descr 

 , e.emplid 

 , n.NAME 

  FROM ps_tl_empl_data e 

  , ps_tl_group_dtl a 

  , ps_tl_group_tbl g 

  , ps_names n 

  , ps_tl_grp_security s 

  , psoprdefn o 

 WHERE a.emplid = e.emplid 

   AND n.emplid = e.emplid 

   AND n.name_type = 'PRI' 

   AND n.effdt = ( 

 SELECT MAX (n1.effdt) 

  FROM ps_names n1 

 WHERE n1.emplid = n.emplid 

   AND n1.name_type = 'PRI' 

   AND n1.name_type = n.name_type 

   AND n1.effdt <= SYSDATE) 

   AND a.GROUP_ID = s.GROUP_ID 

   AND a.emplid <> o.emplid 

   AND e.effdt = ( 

 SELECT MAX (e1.effdt) 

  FROM ps_tl_empl_data e1 

 WHERE e1.emplid = e.emplid 

   AND e1.empl_rcd = e.empl_rcd 

   AND e1.effdt <= SYSDATE) 

   AND a.group_id = g.group_id

 

enjoyy bhayya 

 

'psoprdefn' table trouble istundi, andulo key field 'OPRID' kani ee field ee sql lo ekkada use cheyalemu.

 

ne eshallo....design kuda teliyali kada...so that join marchataniki emina ideas vastai

[Yuvatha]

ne eshallo....design kuda teliyali kada...so that join marchataniki emina ideas vastai

inka vere ye tables lo leda oprid?

[SUbba LIngam]

inka vere ye tables lo leda oprid?

 

lite le bhayya, nene edo okati trying settaa le 

[Yuvatha]

lite le bhayya, nene edo okati trying settaa le 

haha...chusanu query ni...like i said, ne tables info full ga unte..i can try better