I actually wonder why you would want to delete it in the first place anyway. If it's a foreign key, then those other tables are relying on it for referential...

Could you perhaps provide the data in a consumable SQL format? Many of us are unable/not allowed to download untrusted Excel files, as we use the forums while at work.

Personally, I'd use a calendar table (Bones of SQL - The Calendar Table) and calculate from that..

Then, using a Function, you could do something like this...

I rarely RDP to the server either. The only times I do is, like Lynn said, when it's something I'd want to be at the physical server for anyway. Last...

No sample,or DDL, so untested, and no expected result set, but maybe...:
SELECT cr.ReferralId, o.CustomerID, o.OrderID
FROM orders o
    CROSS APPLY (SELECT TOP 1 *
   ...

Personally, I would go with a Stored Procedure and parametrise it. One, problem, however, is that you do have several options, and ideally, you want to use an IF statement...

You can set up something yes, but how depends. If, for example, you use a Stored procedure, you'd need to look for records that have been added. How do you...

You don't "delete" from views. Views are simply a predefined SELECT statement. If you need something deleted that is displayed in a view, you have to delete it from the...

Hadn't noticed this was SSRS (after seeing the first answer). An SSRS expression would be:
=DATEADD("M", DATEDIFF("M", "01/01/2000", DATEADD("d", -1, TODAY())), "01/01/2000")
Effectively, like John said, the same, but SSRS...

If you have two expressions, maybe combine the two into a filter and a BOOLEAN result? In simple terms, effectively:
=IIF(([SUM EXPRESSION 1] = 0) AND ([SUM Expression 2] =...

The reason it doesn't pick it up as an issue is that currently, that format is still permitted. In SQL 2016, 'string_alias' = expression will be accepted, however, it will...

Just declare a static value column?
SELECT [YourField] AS Broken, 2000 AS AllCars
FROM [YourTable];