SELECT c.CustomerID
    , SUM(t.amount) AS TotalAmount
FROM Customer c
CROSS APPLY (SELECT TOP 2 o.*
            FROM Orders o
            WHERE o.Customer = c.CustomerID) t
GROUP BY c.CustomerID
HAVING SUM(t.Amount)>150;

If you want YYYY - YYYY then you have to cast the Years as strings, otherwise, T-SQL will interpret the + as the addition operator. Check out CAST()

Welcome to SSC.  It helps everyone if you post CREATE TABLE and INSERT scripts so people can run them and have at least a mockup of what you're dealing with....

Rod,
if you have an HDMI port on your computer, send the signal to your TV.  Just display some stuff on your computer screen and some on the TV. That's...

This is trivial in SSRS.
Connect to your datasource, create your dataset, drop in a matrix.
People are on rows, Dates are on columns. Add a parameter for the start...

You could use REPLACE(), but there are no spaces in that string to begin with. 

DECLARE @TextWithSpaces VARCHAR(100) = 'I have a whole lot of spaces';
PRINT REPLACE(@TextWithSpaces,' ','');

Looks like this works...
You may want to include other rows from both tables, but this should give you the gist of how to do it.
use AdventureWorks2014;

Do you mean like this?  (Note: I had to change your comparison date.)

DECLARE @CurrTime DATETIME = '2016-09-09 18:13:00.000';

UPDATE #JobHistory
SET [Status]=2
WHERE ModifiedDate<=@CurrTime;

But that leaves orphan records. Can you not populate the parent table first?

I supposed you could disable the check constraints, but why would you? Populating the child table...

I did that with Store table (contains Surface Area), and Sales. I created a Total Surface Area measure = SUM(Store[SurfaceArea]) and put Store and SalesType on Rows, and Total Surface...

Please explain what the measure you're creating is meant to calculate... and how it's meant to work. I think you may have a math error in your formula, but without...

FFS, how about some real tables? Since you didn't provide consumable data, here's my best guess.  

SELECT CM.cust_no
  , loc_No
FROM Cust_Master CM
WHERE...

With a tally table, this is pretty easy:

DECLARE @max-2 INT;
SELECT @max-2 = MAX(Quantity) FROM #Test;

SELECT ID
    , ProductCode
    , Quantity
FROM #Test te

DelimitedSplit8K would work, if you want that returned as a table (so each day of the week would be a record)...

That's what I was gonna say... If I had the option, I'd do this in SSRS.. .Could do this in about 20 seconds.