you cannot use kill with a variable. one way to overcome this problem is using dynamic sql.

your query will return MAX(Quantity) for each PurchaseNo. but i want to get something else. Consider the following de-normalized view of data:

StockId P_No P_Date ItemId Quantity

1 1 1/1/2004 100 50

1 2 1/2/2004 100...