My first question was whether ITEMS.UnitCost was character.  If so, the coalesce would change the sort method from alphabetic to numeric, which could have a profound effect on the sort...

One is a proper subset of the other.  Also, sub-queries are necessarily nested, so nobody uses the term nested.

Drew

This is a fairly standard gaps and islands problem.

WITH gaps_and_islands AS
(
    SELECT *, DATEADD(DAY, -ROW_NUMBER() OVER(PARTITION BY RecordID, Quantity ORDER BY dateID), dateID) AS...

It never ceases to amaze me how many people think that the error message is irrelevant to resolving an error.

Drew

Multi-select parameters are passed to stored procedures as a comma-delimited list.

Drew

English is obviously not your first language.  This post has nothing to do with the forum that it was posted in and your description of the problem is almost unintelligible.

You can't given the data provided.  SQL tables represent sets, which are unordered.  Your output requires an order that is not supported by your data.  There is no way to...