In this table I am storing Quantity daywise.

as

Id Sunday Monday Tuesday Wednesday

1 2.00 2.00 2.00 ...

I need output as below...

...

Create table temp (Y bit,Ref_No Varchar(50),Ref_Date datetime,Credit numeric(18,2),Debit numeric(18,2), type )

in case of Credit amount

insert into ('0','Cash-Mem-245','2011-05-11','2500.00','0.00','C')

in case of Debit amount

insert into ('0','Mem-245','2011-05-11','0.00',250'0.00','B')

Sorry sir,

That was previous query..

expect query is

select T1.Y,T1.[REF NO],T1.[REF DATE],T1.CREDIT,T1.DEBIT,T1.[TYPE],

(Sum(T2.DEBIT)-Sum(T2.CREDIT))as BALANCE from temp T1

inner join temp T2 on T2.Row<=T1.Row ...

To Do so I have written a query as

select T1.Y,T1.[REF NO],T1.[REF DATE],T1.CREDIT,T1.DEBIT,T1.[TYPE],

(Sum(T2.DEBIT)-Sum(T2.CREDIT))as BALANCE from temp T1

inner join temp T2 on T2.Row<=T1.Row...

Thanx it working for me....

Thank you its working but I can not modify table defination

the table definition is

create table tbtemp (temp varchar(50))

My table contains only one column and information store in this table as follow

Hii Every body

I retriving data from database and my...

i want to set grade A for these students who's marks in bet ween 99 to 90 its mean there may multiple rows updated at a time.

Actually I went for an interview there interviewer asked me for retrieve row id from a specific table. But I replied so confidently that sql server doesn't assign any Row...

As we know that each row have its own id in each table provided by DMBS software. I want to fetch that row ID for specific table

How to do so??

Can you send me query for this

Ya its work thanx sir

But i want to group by only with email, because some time names are different but emails are same so i need to result according to group of email. so...

Hi thank You for replying but this query provide the information of these records which are entered in database.