Hi Rajesh,

this article might be what you are looking for:

http://www.sqlservercentral.com/articles/articlelink.asp?articleid=2702


>I want to add a balance field to this query how do I achive this
>
>
>select outdt as date ,packsetid, shetkariid,
>sum(inqty) as inqty, sum(outqty) as outqty , ****running balance field***
>from stkoffset
>where packsetid = @p_packsetid and shetkariid = @p_shetkariid
>group by packsetid, shetkariid, outdt
>order by packsetid, shetkariid, outdt
>
>Rajesh