Actually the solution you provided is not giving me the correct result. Not even mine changes are working. For example:

DECLARE @Friendship TABLE

(PersonID INT,

FriendID INT)

--Person:Friend relationship entry

INSERT @Friendship

SELECT 1,...

Hi The Dixie Flatline. Sorry for my late response. Your solution was almost what I needed. There was a little discrepancy in the result. To fix that I had to...

Thanks Sean. This indeed is perfect and sorry for my late response.

Thanks Hugo,

This is spot on. That's why my query was misbehaving. I was iterating the rows "1" leave at a time. The moment a fraction either in "available" or "requested"...

Well, the result is already sorted by "priority". Since it is a part of a stored procedure that returns the result set, I have included it as a temp table....

Thanks for the reply. Actually the column names are not fixed. They can vary, plus I can not make changes to any table schema. So, here is the working query...

Based on the 'toDate'. Last n quarters ending on 'toDate'.

Yes sir. Exactly.

Sir, my reply was for Sachin Nandanwar.

OK. Let me rephrase my requirement. There is a master table that contains records. In this table there is a column 'transactionDate'. There is another table 'Target' that is used...

Exactly.

Sorry if the requirement is not clearly mentioned(English is not my first language). In the example I gave the dates the user passed are June 05, 2010 and June 30,...

No. The requirement is quite clear. If the user wants to find last 5 week's data from the table and he has the upper range for date say, June 10,...

The problem with my data is it comes as a result of a lot of calculation in a stored procedure. In the end there is only one temporary table that...

The problem with my data is it comes as a result of a lot of calculation in a stored procedure. In the end there is only one temporary table that...