| Author |
Message |
    
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8455
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 8:38 pm: |    |
Gochi :piccha fastgaa unnaavgaa hemesh
migilinavi PO issues..vendor bank setups etc gochesh..oka assalainadi undi..PO approval hierarcy, apporval limits, evadiki PO create chese rights unnay, evariki approve chese rights unnay...veetiki data pampanu internal auditors ki...aame evo 10 questions tho mail kottindi..ippudu andulo okokkati soodali... .. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8454
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 8:36 pm: | |
Racchamass :ammani pipty miss
 |
Racchamass
Celebrity Bewarse
Username: Racchamass
Post Number: 16882
Registered: 01-2005
Posted From: 76.182.87.40
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 8:33 pm: | |
ammani pipty miss 
Our greatest glory is not in never falling, but in rising every time we fall |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57427
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 8:32 pm: | |
piccha fastgaa unnaavgaa hemesh
Bewarse Legend Of The Year 2008 Award winner  |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8453
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 8:30 pm: | |
inka oka 3 tasks unnay anthe... |
Racchamass
Celebrity Bewarse
Username: Racchamass
Post Number: 16880
Registered: 01-2005
Posted From: 76.182.87.40
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 8:30 pm: | |
49
Our greatest glory is not in never falling, but in rising every time we fall |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 4966
Registered: 09-2006
Posted From: 66.30.108.90
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 8:29 pm: | |
hemu  ..
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Racchamass
Celebrity Bewarse
Username: Racchamass
Post Number: 16878
Registered: 01-2005
Posted From: 76.182.87.40
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:51 pm: | |
saala matter undi kada taadu lo
Our greatest glory is not in never falling, but in rising every time we fall |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8452
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:49 pm: | |
inka oka 12 tasks paina unnay cheyyalsinavi..ide intha time pattindi |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8451
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:48 pm: | |
hmm...evaro kani bagane idea ichadu pivot ani...asala xls file ni ala soothante kannula pandaga ga undi..kiki. US and Canada vendors ki run chesi pampesa... |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57422
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:40 pm: | |
emo ayyundocchu....IP soosthe georgia state soovisthaandhi
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8450
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:39 pm: | |
emo mari.. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57421
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:38 pm: | |
inthaki ee gochidada evalu......
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8449
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:37 pm: | |
thanks beeresh for the basic query...thanks gochidada for the pivot query...thanks goches for the continous support and max help...kiki. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57420
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:35 pm: | |
venjoyy.....
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8448
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:33 pm: | |
run ayyindi gochesh..kiki..
SELECT Vname,
Vnum,
max(decode(payment_month, 'JUL-07', payment_amount, null)) "Jul-07",
max(decode(payment_month, 'AUG-07', payment_amount, null)) "AUG-07"
FROM (SELECT pv.vendor_name Vname,
pv.segment1 Vnum,
to_char(ac.check_date, 'MON-YY') payment_month,
sum(aip.amount) Payment_Amount
FROM ap_invoice_payments aip,
ap_invoices ai,
ap_checks ac,
po_vendor_sites pvs,
po_vendors pv,
ap_bank_accounts aba,
ap_terms at_v,
ap_terms at_vs
WHERE aip.invoice_id = ai.invoice_id
AND aip.check_id = ac.check_id
AND ai.vendor_site_id = pvs.vendor_site_id
AND pvs.vendor_id = pv.vendor_id
AND ac.bank_account_id = aba.bank_account_id
AND pv.terms_id = at_v.term_id (+)
AND pvs.terms_id = at_vs.term_id (+)
AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY'))
AND NVL(:p_date_to,SYSDATE)
GROUP BY pv.vendor_name,
pv.segment1,
to_char(ac.check_date, 'MON-YY')
order by to_char(ac.check_date, 'MON-YY'), pv.vendor_name)
group by VName, VNum |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8447
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:32 pm: | |
naaku problem ardamaindi..correct chesthunna..running query.. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8446
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:21 pm: | |
exactly gochesh..alage vasthundi data..oh ardamaindi..kani max pedithe indaka ichina error vasthundi  |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57419
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:12 pm: | |
without max neeku ee format lo raavali data....
ID, July, August,September
1,400,-,-
1,-,500,-
1,-,-,600
max pedithe instead of 3 rows,you should get max grouped by each ID
ID, July, August,September
1,400,500,600
ante blanks ni max tho filter chesthunnaavannamaata
Bewarse Legend Of The Year 2008 Award winner |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57418
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:10 pm: | |
group by date theesettey problem undadhu hemesh....endukante manam aa calucations anni select clause lo chesi by date line by line isthunnaam....
aina date theesesaaka kooda same error endhi varitygaa
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8445
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:08 pm: | |
assala max enduku pettali??? |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8444
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:06 pm: | |
emaindi chippesh...nenu ee query ki oka half day chesa ante gundelu badukuntaru company vaallu..kiki. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8443
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:06 pm: | |
same error..kani group by thesesthee assala beeresh ichindi raademo ga...ayina group by lo date di thesesina same error |
Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow
Post Number: 4774
Registered: 05-2008
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:04 pm: | |
 |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57417
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:03 pm: | |
emantaandhi ippudu
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8442
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:03 pm: | |
sesa gochesh... |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57416
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:02 pm: | |
kinda group by lo date theesesaa...try this
SELECT pv.vendor_name Vname,
pv.segment1 Vnum,
max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07",
max(decode(to_char(ac.check_date, 'MON-YY'), 'AUG-07', sum(aip.amount))) "AUG-07"
FROM ap_invoice_payments aip,
ap_invoices ai,
ap_checks ac,
po_vendor_sites pvs,
po_vendors pv,
ap_bank_accounts aba,
ap_terms at_v,
ap_terms at_vs
WHERE aip.invoice_id = ai.invoice_id
AND aip.check_id = ac.check_id
AND ai.vendor_site_id = pvs.vendor_site_id
AND pvs.vendor_id = pv.vendor_id
AND ac.bank_account_id = aba.bank_account_id
AND pv.terms_id = at_v.term_id (+)
AND pvs.terms_id = at_vs.term_id (+)
AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY'))
AND NVL(:p_date_to,SYSDATE)
GROUP BY pv.vendor_name,
pv.segment1
order by pv.vendor_name
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8441
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 7:01 pm: | |
SELECT pv.vendor_name Vname,
pv.segment1 Vnum,
max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07",
max(decode(to_char(ac.check_date, 'MON-YY'), 'AUG-07', sum(aip.amount))) "AUG-07"
FROM ap_invoice_payments aip,
ap_invoices ai,
ap_checks ac,
po_vendor_sites pvs,
po_vendors pv,
ap_bank_accounts aba,
ap_terms at_v,
ap_terms at_vs
WHERE aip.invoice_id = ai.invoice_id
AND aip.check_id = ac.check_id
AND ai.vendor_site_id = pvs.vendor_site_id
AND pvs.vendor_id = pv.vendor_id
AND ac.bank_account_id = aba.bank_account_id
AND pv.terms_id = at_v.term_id (+)
AND pvs.terms_id = at_vs.term_id (+)
AND ac.check_date BETWEEN NVL(:p_date_from,TO_DATE('01-JAN-1950', 'DD-MON-YYYY'))
AND NVL(:p_date_to,SYSDATE)
GROUP BY pv.vendor_name,
pv.segment1,
to_char(ac.check_date, 'MON-YY')
order by pv.vendor_name |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57415
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:58 pm: | |
kindha group by add seyyu migathaa columns ki (columns not having max in select clause).... 
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8440
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:56 pm: | |
Gochi :alaa aithe mundu oka max padeyyi
not a single group group functionantundi max add chesthe..
ORA-00937 not a single-group group function
Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause.
Action: Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8439
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:54 pm: | |
|
Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow
Post Number: 4773
Registered: 05-2008
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:49 pm: | |
aythey ee work ki nuvvu chese billing lo 50% db ki kattu  |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57414
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:49 pm: | |
alaa aithe mundu oka max padeyyi....decode and case statement are exactly the same....
max(decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount))) "Jul-07",
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8438
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:47 pm: | |
Shadow :Bemmam db valla chetha work seyichhavantey na
 em seyyanu mama...3 days postpone sesaa query dorakka..query dorikaka ee problem |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8437
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:46 pm: | |
Idi work ayyindi gochesh..
decode(to_char(ac.check_date, 'MON-YY'), 'JUL-07', sum(aip.amount)) "Jul-07",
just 2 months ki try chesa...
vendor1 ki 2 rows vachi okokka row lo okokka month ki display avuthunnay values...so adi correct cheyyali... |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57413
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:44 pm: | |
shado baa
Bewarse Legend Of The Year 2008 Award winner |
Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow
Post Number: 4772
Registered: 05-2008
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:42 pm: | |
Bemmam db valla chetha work seyichhavantey na  |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57412
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:33 pm: | |
select
max(case when (year(payment_date) = 2007 and month(payment_date) = 07) then sum(payment)) "July-07",
idhi try chesi choodu....
Bewarse Legend Of The Year 2008 Award winner |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8436
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:33 pm: | |
ippudu endo missing keywork antundi..sare chostha aagu.. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8435
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:28 pm: | |
Gochi :select
max(case when to_char(payment_date,'MON-YY') = 'Jul-07' then sum(payment)) "July-07",
max(case when to_char(payment_date,'MON-YY') = 'Aug-07' then sum(payment)) "Aug-07",
etc etc...
ilaa raasi choodu hemesh, okko nelaki okkoka line raayali.....appudu column wise pivot avuthundi
invalid relational operator = antundi...tochar annamana endi?? |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57411
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:26 pm: | |
Registered: 01-2007
eppudo register sesukuni after 2yrs ippudu postings settunnaava gochidada
Bewarse Legend Of The Year 2008 Award winner |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57410
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:21 pm: | |
select
max(case when to_char(payment_date,'MON-YY') = 'Jul-07' then sum(payment)) "July-07",
max(case when to_char(payment_date,'MON-YY') = 'Aug-07' then sum(payment)) "Aug-07",
etc etc...
ilaa raasi choodu hemesh, okko nelaki okkoka line raayali.....appudu column wise pivot avuthundi
Bewarse Legend Of The Year 2008 Award winner |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 57409
Registered: 07-2004
Posted From: 24.229.138.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:15 pm: | |
eee gochidada evalu
Bewarse Legend Of The Year 2008 Award winner |
Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow
Post Number: 4771
Registered: 05-2008
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:13 pm: | |
>>If you want to know more about it, there is this website called www.google.com
 |
Shadow
Yavvanam Kaatesina Bewarse
Username: Shadow
Post Number: 4770
Registered: 05-2008
Posted From: 68.198.151.34
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:12 pm: | |
Gochidada, olu nuvvu |
Gochidada
Pilla Bewarse
Username: Gochidada
Post Number: 4
Registered: 01-2007
Posted From: 67.159.44.138
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:10 pm: | |
Pivot query is just a way of cheating regular query to get the desired output in column format. google it and you will see many examples. |
Gochidada
Pilla Bewarse
Username: Gochidada
Post Number: 3
Registered: 01-2007
Posted From: 67.159.44.138
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:08 pm: | |
you have to use pivot query to see column wise output.
If you want to know more about it, there is this website called www.google.com |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8434
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:07 pm: | |
Gochidada :you have to use pivot query to see column wise output
idendi...???? |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8433
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 6:00 pm: | |
bagane work avuthundi kaani rows lo vasthundi... thanks beeresh... |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8432
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 5:53 pm: | |
beeresh...aagu sootha...nenu inka each month ki ichi payment_date between ani save cheshunna file ni |
Gochidada
Pilla Bewarse
Username: Gochidada
Post Number: 1
Registered: 01-2007
Posted From: 67.159.44.138
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 5:50 pm: | |
Ravanabrahma :
wonder what is your job title ,your billing rate, years you have been working here |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 4965
Registered: 09-2006
Posted From: 66.30.108.90
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 5:50 pm: | |
select to_char(payment_date, 'MON-YY'), sum(payment)
from table
group by to_char(payment_date, 'MON-YY')
order by to_char(payment_date, 'MON-YY')
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8431
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Sunday, January 11, 2009 - 5:35 pm: | |
payment_date month ni batti sum chesi different months ki rastham elagu?? |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 8430
Registered: 06-2004
Posted From: 65.196.167.82
Rating:
Votes: 1(Vote!) | | Posted on Sunday, January 11, 2009 - 5:30 pm: | |
Vendor payments ki query raayali..Jul-07 to Dec-08 varaku..
oka month lo vendor ki chala invoices payment untundi..like Jul-07 lo oka 20 invoices(with different payment dates) untay..ippudu emi data kaavali ante..
Vendor_name Jul-07 Payment, Aug-07Payment, Sep-07 Payment,.....
each month ki sum chesi raavali query...elaa raayali adi?? |
