| Author |
Message |
    
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 8753
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Tuesday, June 27, 2006 - 4:03 pm: |    |
hemu ga crystal reports medha pani chesava nuvvu 
nenu dani medha thega pighting dotnet lo ettadaniki  |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17626
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Tuesday, June 27, 2006 - 3:25 pm: | |
mandu party. kiki.nenu pepsi thagutha. nani ki maa vadu adv ichadu ga. kiki. |
Pokiri1
Kurra Bewarse
Username: Pokiri1
Post Number: 944
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Tuesday, June 27, 2006 - 3:23 pm: | |
/andam vindolam assale chalikalam, adharam thambulam... ane song pedadam, kevv anala./
 |
Nitho
Desanike Pedda Bewarse
Username: Nitho
Post Number: 7627
Registered: 12-2004
Posted From: 161.225.1.12
| | Posted on Tuesday, June 27, 2006 - 3:22 pm: | |
hemantha
em party istunnav inthaki |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17625
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Tuesday, June 27, 2006 - 3:21 pm: | |
ledu mama. bayatakelli iragedham. chiru songs etti kummedham.
andam vindolam assale chalikalam, adharam thambulam... ane song pedadam, kevv anala. |
Pokiri1
Kurra Bewarse
Username: Pokiri1
Post Number: 942
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Tuesday, June 27, 2006 - 3:19 pm: | |
|
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 23799
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, June 27, 2006 - 3:19 pm: | |
 nee parties elaaguntaayo naaku telusu...gumpugaa vaccheyandi iragadeesukundhaam ani seppi mammalni pokiri theatre bayatiki theesakelli thalaa o banner maakicchi cake kosi D'thinandi antaav anthegaa..
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17622
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Tuesday, June 27, 2006 - 3:16 pm: | |
oka roju manchi party chesukundam le mama. kiki. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 23797
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, June 27, 2006 - 3:15 pm: | |
 ittanti dealslo paisalu anni nuvvu dobbesi asalu nee work anthaa settunna naaku,Nayak maamaki nuvvu sesindentani khandisthunnanu ...
yekku toli mettu kondanu kottu deekottu gattiga patte nuvv pattu gamyam cherettu |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17609
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Tuesday, June 27, 2006 - 2:58 pm: | |
iragadesale assala. kiki. ee thokkalo daniki okadu 4 hours time ivvu annadu, aadu gantaki charge chesedi 220$. aadebha. oracle vadu kadu, do crystal report chesi istha annadu, maa vadiki nenu setha le ani seppa, aadu vaccation lo unnadu, repu vachesthadu ani ivvala buddi petta. kiki. |
Nitho
Desanike Pedda Bewarse
Username: Nitho
Post Number: 7619
Registered: 12-2004
Posted From: 161.225.1.12
| | Posted on Tuesday, June 27, 2006 - 2:54 pm: | |
Hemantha dhaniki 10 mins endhuku
okka sari gatti burra gokithe adhe vachestundhi ga |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17608
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Tuesday, June 27, 2006 - 2:53 pm: | |
gochi ga, idi pani seyyala, vere ga trying sesa, pani sesindi. naaku koda sql queries rastham vachesindoch. correct ga oka 10 mins alochincha. vachesindi. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 23333
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Wednesday, June 21, 2006 - 4:15 pm: | |
 maama alaa aithe subqueryni main querytho outerjoin cheyyi...anthe gaani alaa join cheyyakundaa vadilesthey output raadhu leka thapposthundhi...
approver employees listlo untaadu kaabatti..
xx.employee_id/name = EA.emplyee_id/name(+)
ani etti try seyyi |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17382
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 3:44 pm: | |
tyre ga, nayudu id tho savadobbuthunnav ga janalni. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17381
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 3:42 pm: | |
 |
Tyrael
Kurra Bewarse
Username: Tyrael
Post Number: 986
Registered: 05-2006
Posted From: 65.174.40.114
| | Posted on Wednesday, June 21, 2006 - 3:39 pm: | |
kevvvv, |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17380
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 3:18 pm: | |
akkada oka employeename vachi approver di, inkoka employee name emo aa approver kinda undevalladi. antha employees ee kani. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17379
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 3:17 pm: | |
ok mama, seat lo lenu indaka. sare mama aagu chosthanu. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 23332
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Wednesday, June 21, 2006 - 3:06 pm: | |
maama...nenu intiki goings...oka ganta tharavatha malli vasthaa.. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 23331
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Wednesday, June 21, 2006 - 3:02 pm: | |
EA.employeename = xx.employee_name ani main querly lo ekkadanna join cheyyi maama...
oka vela name unique kaakapothe subquerylo ID kooda pull chesi main querylo join seyyi |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17378
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 3:00 pm: | |
aa where or second select thappu peduthunna ekkado?? |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 23330
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Wednesday, June 21, 2006 - 3:00 pm: | |
 nee yenks subquery ni main querytho ekkada join settunnavu.. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 23329
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Wednesday, June 21, 2006 - 2:56 pm: | |
 ippude thaadu choosa..undu maama artham sesukuni septhaa.. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17377
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 2:35 pm: | |
ardam ayi savaleda. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17376
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 2:34 pm: | |
ee condition pedithe aa chain lo unna employees vastharu.
and FEAC.FilterableElementValue = E.EmployeeCode |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17375
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 2:33 pm: | |
Only approver list ki ee query pani chesthundi.
select distinct EmployeeName
from ApprovalChain AC,
ApprovalChainApprover ACA,
FilterableElementApprovalChain FEAC,
Employee E
where AC.ApprovalChainId = ACA.ApprovalChainId
and ACA.ApprovalChainId = FEAC.ApprovalChainId
and ACA.approverID = E.EmployeeId |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 17374
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Wednesday, June 21, 2006 - 2:32 pm: | |
naa daggara konni tables unnayi.
idi expense system ki. prathi konthamandi employees ki oka approver untadu. oka approval chain untundi, daniki approver oka employee, a chain lo kontha mandi employees untaru. aa 3 columns retreive cheyyali ippudu.
idi vaduthunna. kani ravatam laa. thappu vasthundi ekkada thappu chesthunnanu??
select distinct AC.approvalChainName, E.EmployeeName, EA.EmployeeName
from ApprovalChain AC,
ApprovalChainApprover ACA,
FilterableElementApprovalChain FEAC,
Employee E,
(select distinct EmployeeName
from ApprovalChain AC,
ApprovalChainApprover ACA,
FilterableElementApprovalChain FEAC,
Employee E
where AC.ApprovalChainId = ACA.ApprovalChainId
and ACA.ApprovalChainId = FEAC.ApprovalChainId
and ACA.approverID = E.EmployeeId) EA
where AC.ApprovalChainId = ACA.ApprovalChainId
and ACA.ApprovalChainId = FEAC.ApprovalChainId
and ACA.approverID = E.EmployeeId
and FEAC.FilterableElementValue = E.EmployeeCode
group by EA.EmployeeName, AC.approvalChainName, E.EmployeeName |
