DECLARE	@DBAmt FLOAT,
	@PartyCode VARCHAR(10),
	@AccCode VARCHAR(10),
	@AsonDate DATETIME,
	@YrSrNo INT

SELECT	@PartyCode = 'N43',
	@AccCode = '000175',
	@AsonDate = '03/31/2008',
	@YrSrNo = 7

SELECT		@DBAmt = SUM(fAmount)
FROM		VRHeader AS h
INNER JOIN	VRDetail AS d ON d.vVRNo = h.vVRNo 
			AND d.vVRType = h.vVRType
			AND d.iYrSrNo = h.iYrSrNo
			AND d.vAccCode = @AccCode
			AND d.vDCFlag = 'D'
			AND d.vPartyCode = @PartyCode
INNER JOIN	AccountHeads AS a ON a.vAccCode = d.vAccCode
WHERE		h.dvrdate <= @AsonDate
		AND h.iyrsrno = @YrSrNo
		AND h.vVRType = 'BANK'

SELECT	@DBAmt