| Author |
Message |
    
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 417
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 8:19 pm: |    |
Sunil one more 
http://img208.imageshack.us/img208/7635/sunil2sl2. gif |
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 416
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 8:14 pm: | |
Sunil
http://img212.imageshack.us/img212/97/sunildo3.gif |
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 415
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 8:08 pm: | |
mana db lo ettu adi  |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 47990
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 8:02 pm: | |
 bagundi chippesh  |
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 414
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:59 pm: | |
http://img208.imageshack.us/img208/5928/katrajcn8. gif |
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 413
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:56 pm: | |
Ali ganidi too much undi  |
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 412
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:56 pm: | |
idi create chesa
http://www.gifninja.com/Workspace/29457d83-4d23-4d 8a-a7f2-44ea888814d3/output.gif |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5005
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:39 pm: | |
avatharala kosam comedy ga design chesina clipart idi. kiki.
http://img220.imageshack.us/img220/8721/whatvx8.gi f |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5004
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:38 pm: | |
maradee....saana kattam avi setham, correct ga oka frame nunchi oka frame ki cutting seyyali. madhyalo konni frames theseyyali.
pfdb lo kurrollu dash margam ga cut chesi paara nookuthunnaru mari. |
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 411
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:35 pm: | |
nenu oka sari try chesa trial version tho..ippudu expire ayipoyndy  |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5003
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:31 pm: | |
googling sesa mama. video cutter or slicer ani type sesi sesa. avi malla trial versions ee. rendu softwares download cheyyali alantivi. frames ga vasthayi. vaatini combine cheyyali ento. madhyalo konni frames thesesi ..ante oka expression lo 10 frames lo oka 5 thesesina same frame vasthundi. ala thesesi combine cheyyali size thakkuva kosam. naku aa software names koda gurthu lev ippudu. |
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 409
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:27 pm: | |
ee s/w tho try chesav ikkada postu |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5002
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:22 pm: | |
naaku avi ela cheyyalo theliyadu mama. okasari try chesa. kastapadi oka 3 icons chesa. doola theripoyindi. naa valla kadu ani vadilesa. akkada vallu usharaina uuth sesaru vaatini inka. |
Khanna
Pilla Bewarse
Username: Khanna
Post Number: 408
Registered: 04-2005
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:20 pm: | |
bemmam mayya nuvvu brahmam icons mana db lo kuda pettochhu ga  |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5001
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:19 pm: | |
hahaha, sarle. lite. rendu lists ichestha vadiki. vaade subtract chesukuntadu manual ga. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 47986
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:17 pm: | |
edavatledehess...okka mukka artham kaaledhu,andukani aa espression etta  |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 5000
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:16 pm: | |
nenu edavali ga, nuvvenduku edusthunnav gochi mama  naaku help chesi peduthunnava |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 47984
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:13 pm: | |
 |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4999
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:12 pm: | |
anni transactions list and expense report lo undi ready for inclusion ani unna list ichi chosuko ante emanna anukuntademo  |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4998
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 7:08 pm: | |
oh chardcardtransaction enduku null undo ardmaindi. cash transactions ga manual ga add chesaru kabatti expense report lo. hmm ee point emanna upayogapaduthundemo chostha. |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4997
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:57 pm: | |
null unte undindi le ani rasthe emi result raledu. kiki. |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4996
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:54 pm: | |
assala a and d tables renditiki common ga oka column undi. cctransactionnumber ani.
paina add chesina rendu conditions add cheyyakunda where a.cctransactionnumber not in (select cctransactionnumber from d) ante saripothundi.
kani d.cctransactionnumber values chala varaku null unnayi. enduko theliyadu |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4995
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:52 pm: | |
and a.spentexpenseamount = d.SPENTEXPENSEAMOUNT
and a.transactiondate = d.SPENTDATE
ee rendu ippudu add chesa. avi add cheyyaka mundu anni ready for inclusions ichesindi. avi add chesaka only expense reports lo add ayi still ready for inclusion ani unna transactions isthundi. naakemo reverse kavali. |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4994
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:50 pm: | |
migilina tables anni marchipoya gochai. only a and d tables main target. |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4993
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:49 pm: | |
mundu anni rakala vatiki upayogapadindi ani ala case rasa. next aa rendu status lu unnave kavali annadu. aa next kavalsindi ready for inclusion only annadu. so aa condition where lo petta kani paina thiyyakunda unchesa. kiki. |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4992
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:48 pm: | |
ammani soosi dobbava. mundu kavali ani case statement petta. aa next avasaram ledu anipinchindi. theseyyochu kani badhakamesi unchesa. neeku bagane ardamaindi mama ayithe query. kiki. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 47982
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:45 pm: | |
case a.CCtransactionstatus
when '8' then 'Invalid'
when '0' then 'Ready for Inclusion'
end as Status,
idhi pettaavu baane undi,malli kindha where lo
and a.CCtransactionstatus in ('0')
idhi edithe inka nee case statement enduku,naalika geesukoneeki kooda panikiraadhu,ante '8' vache scene ledugaa  |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 47981
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:42 pm: | |
|
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4989
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:33 pm: | |
nenu aavesam gaa ee query rasanu. kani idi emi list chesthundi ante ready for inclusion ani status undi..aa transactions expense report lo add cheyyabadi unna transactions list isthundi. naku exact opposite kavali. |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4988
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:32 pm: | |
select c.employeename,
f.departmentname,
c.employeenumber,
a.spentexpenseamount,
c1.currencycode,
a.expensedescription,
case a.CCtransactionstatus
when '8' then 'Invalid'
when '0' then 'Ready for Inclusion'
end as Status,
a.TransactionDate,
a.createstamp
from ChargeCardTransaction a, chargecard b, employee c, currency c1, Department f, EmployeeCorporateInfo eci, expensereportitemtrans d
where --a.modstamp is null
a.ChargeCardId = b. chargecardid
and b.employeeid = c.employeeid
and a.spentcurrencyid = c1.currencyid
and a.CCtransactionstatus in ('0')
and c.employeeid = eci.employeeid
and c.employeeid = a.employeeid
and eci.departmentid = f.departmentid
and a.spentexpenseamount = d.SPENTEXPENSEAMOUNT
and a.transactiondate = d.SPENTDATE
and transactiondate > '2007-05-01 00:00:00.000'
order by transactiondate |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4987
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:29 pm: | |
ala common ga unna unique column ledu gochi mama. oka 3 columns values indulo andulo okati untundi anthe. hmm. edo idea vasthundi aagu chostha |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 47978
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:24 pm: | |
 hemesh,minus cheyyalante simplegaa where clause tharavatha "not in" ani ante saripothundi...example ki a,b tables anuko nee daggara unnavi
select a.x_id,a.x_amount
from account a
where a.x_id not in (select b.x_id from Bonux b)
oka vela B table lo emanna join cheyyali ante aa subquerylo join cheskovachu... |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 4986
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, September 30, 2007 - 6:18 pm: | |
nenu oka query rasanu. adi emi choyisthundi ante..all amex card transactions with the status ready for inclusion.
ante aa transaction ni expense report lo include chesukovachu. ala chesaka avi undav inka ready for inclusion laga. kani konthamandi include cheyyakunda cash transactions gaa expense report lo manual ga type chestharu. ante aa ready for inclusion lo unna expense alage untundi. kani employee reimburse chesukuntunnnadu. ippudu kavalsindi entante..I need to list only the transactions that are ready for inclusion. ready for inclusion ani undi, expense reports lo unnavi eliminate cheyyali.
cctransactions ane table lo ee ready for inclusion transactions untayi
expensereportitemtrans lo expense items untayi
common columns spentdate, employeeid, spentamount.
ela minus cheyyalo theliyatam ledu
naa questions ardamainda assala |
