You need a parenthesis to close your first CTE definition, and you need to separate it from the second one with a comma, not a semi-colon.

John

An ETL operation?  What does that look like - simple query with linked servers, an SSIS package, a custom application, something else?  Is it possible that some non-SQL component is...

Take the MAX and MIN status, grouped by ID.  You can then write your CASE expression similar to how you've done above.

John

I don't think you can get column headers natively in T-SQL.  You'd need to use sqlcmd to do the export and then PowerShell or your favourite scripting language to add...

Just put SET QUOTED IDENTIFIER ON at the top of the command in your job step.

John

If you work out what the last Monday was, and what the first Monday in August was, you can do a datediff in weeks to get the week number  There's...

You said you ran it in sqlcmd - that's effectively the same as running it in an SSMS query.  Run the cmd utility in Windows, and execute the command there.

bcp is a command-line utility.  Run it from a Windows command prompt, not as a T-SQL query.

John

I don't really know, but here's a guess:
SELECT
'North Central' AS Region
, nh.Grouping_Level AS Grouping_Level
, (COALESCE(nh.MTDValue,0) - COALESCE(nn.MTDValue,0) ) AS MTDValue
, (COALESCE(nh.MTDTarget,0) - COALESCE(nn.MTDTarget,0)...

Create a user for the login in the same database as the stored procedures.  Grant EXECUTE permission on the stored procedures to the user.  If the stored procedures are all...

Check whether the SQLPS Powershell module is located in the folder specified in the PSModulePath environment variable.  If it isn't, either change the environment variable to the actual path of...

DECLARE @SYSTEM_USER sysname = 'DOMAIN\Joe.Bloggs';
WITH SystemUser (UserName) AS (
    SELECT REPLACE(@SYSTEM_USER,'\','.')
    )
SELECT
     PARSENAME(UserName,2) AS FirstName
,    PARSENAME(UserName,1) AS LastName
FROM SystemUser;

John

The error message tells you exactly what's wrong.  You need to rewrite the subquery so it returns only one value.

John

Use MIN and MAX dateID, grouped by RecordID and Quantity.  That'll work for your sample data, but it'll give strange results if you ever go back to the same Quantity...

I think those numbers refer to the schema versions, not the compile time and run time.

John