There are a couple of ways that you can handle this depending on what you want to do with the results.  Probably the most common is to use a CTE...

Assuming that you have no future dates, you only need to find the begin date and then filter based on that.

DECLARE @pStartDate SMALLDATETIME
SET @pStartDate =...

It comes from the CROSS APPLY.  I did not alter the underlying tables, if that's what you mean.

Make sure that you thoroughly understand this code before deploying it,...

This forum is primarily English. (Türkçe bilmiyoruz.)  You'd get much more of a response if you can post in English.

Drew

This is close.  Your expected results don't seem to match your description.  Specifically rows 40-42 should be in the same group based on "Group continues as long as SkipPrintCompLine= ‘Y’",...

First, we need both sample data AND expected results.  You've only provided half.

January 18, 2018 at 12:53 pm

#1976406

Most people here aren't going to open a zip file posted on the internet.  I suggest that you resubmit your data as outlined in the first link in my signature.

Use a string splitter on both the table field and the parameter, and then use an equality comparison.

Drew