account trans date amount

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

E909 cr 01apr11 8000

E303 ...

thks for your given comments

if suppose em calculting 'o1-apr-2011' and '30-apr-2011'..... wanna the data also perivous year of same month.... and display month column separately

in that same procedure i want to the column of

prev_colsing_bal =(

case...

finally got answer of dis question:

THE QUERY:

************

ALTER procedure TEST_POSTINGS

(

@x datetime,

@y datetime

)

as

begin

--set @x='01-apr-2011'

--set @y='30-apr-2011'

select

locn,

account_no,

Opening_bal=

sum(

case

when...

accountno loct credit ...

expecting output is sample.... dnt consider.... to see opening bal oly.....letter "A" in accuntno=debit-credit ,

...

outlook of the output structer sample,:-)

my query:

select account_no,fs_locn_code,

sum(case when transc ='Cr' then amountelse 0 end) "Credit",

sum(case when transc ='Dr' then amountelse 0 end) "Debit" ,

SUM(CASE WHEN fs_tran_date <'31-mar-2011'and left(account_no,1) in ('A','E') and...

its very urgent any one can help me .....

in my table ve data from 2008 to 2012..... now ve to calculate the "cr-dr" before appearing 01 apr 2011,

i'm wrote query for opening bal ol....

select account_no,locn_code,

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

sum(case when transc ='Dr' then amount else 0 end) "Debit"...

i m workin in server 2000

account transction amount

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

A-1234 Cr 6454

A-8464 Dr 4500

L-435353 Cr 6000

R-5499 dr 8000

from the date of 01 apr 2011 to 30 apr 2011,

here cr is credit, dr is debit

noe i need the...

i need the ouput by using case.... wat u doesnt get it