Does this utility also transfer environment references and variable mappings?

The content of SSIS packages is encrypted during deployment, so you can't retrieve that. But you can query catalog.packages to see which packages have been deployed. What are you trying...

How about you...

Can you post the XML and your desired results?

Another maybe:

DECLARE @RunDateYr INT;

--SET @RunDateYr = YEAR(GETDATE()) * 100;
--SET @RunDateYr = YEAR('20221010') * 100;
--SET @RunDateYr = YEAR('20231010') * 100;
SET @RunDateYr = YEAR('20241010') * 100;

DECLARE @RangeStart INT
 ...

That looks like the SSMS toolbar. I am talking about the toolbar which is displayed when you create a post here:

I have a query that returns 9 rows of data.  I want to remove the rows that cancel each other out by the amt column.  See current results below...

Hi Frederico,

Thank you so much for your answer. I got a couple of questions before my code, if this ok with you. The first and the second CASE are...

What is your question?

If you have Jeff Moden's infamous dbo.DelimitedSplit8K splitter function installed (link), this becomes fairly straightforward:

DROP TABLE IF EXISTS #SomeText;

CREATE TABLE #SomeText
(
    Name VARCHAR(500)...

Does your table have any keys or indexes?

What does 'not working correctly' mean? No results? Error message? Wrong results? Something else?

Note that if TRANSACTION_DATE is a DATETIME (rather than a DATE), BETWEEN is not the recommended way...

I also suggest you start using <> rather than != for 'not equal to'. <> is a more widely accepted SQL standard than !=, as far as I know.

Change your SELECT to

SELECT TOP 100 PERCENT

with the rest of the query remaining as it is.

If you switch the level back to 120, this stops happening?

'First' = first ever, or first since instance was started, or first time in current day?