expected output

account transction openingbal closingbal

======================================================

A-1234 ...

hi Kingston,

I 'm currently working on server 2000,so that pivot won't allow in that version,is any other possibiliies there ah???

hi ,

i got the answer finally

select account_no,

sum(case when trans ='Cr' then amount else 0 end) "Credit",

sum(case when trans ='Dr' then amount else 0 end)...

hi,

some of the accoun tno are repaetd how make groupby accountno

after executing the output ll be

ACCOUNTNO TRANSC ...

please send me as sql query

LOTNO value QUANTITY

============================================

H1207013 ...

hi

the value colum is summarise,if the LOT_NO is reapted 5 times means the value divdied equally....

ex:

H1207013==>2 times came, now i need the value for lot printing ...

raghuldrag (7/18/2012)

---

queryoutput:

=============

company_no location_no issue_no stock_no lot_no value

---------- ---------- ------------- ------- --------- -----

AMRUTFAC MHYD BACK\000000\2008 5000054 [highlight=#ffff11]H1207013 2603.04000000 [/highlight]

AMRUTFAC MHYD BACK\000000\2008 5000153 C2107065 1643.60000000

AMRUTFAC MHYD BACK\000001\2008...

queryoutput:

=============

company_no location_no issue_no stock_no lot_no value

---------- ---------- ------------- ------- --------- -----

AMRUTFAC MHYD BACK\000000\2008 5000054 [highlight=#ffff11]H1207013 2603.04000000 [/highlight]

AMRUTFAC MHYD BACK\000000\2008 5000153 C2107065 1643.60000000

AMRUTFAC MHYD BACK\000001\2008 5000160...

company_no location_no issue_no lot_no quantity confirmed_qt.... value ...

if u dnt mind... wr i have to chck link pls tel clearly

em wrote query like

select a.company,b.location,b.stockno,b.lotno,c.value

from header a

inner join

storage b

on

a.company=b.company

and a.location=b.location

inner join

accounts c

on b.issueno= b.issueno

and a.company=c.company

and b.location=c.location

and b.stockno=c.stockno

its actually 3 tables......

T1="HEADER "

its has compny,location,issueno

T2="STORED DATA"

...