I've done similar set ups.  Dynamic SQL is definitely a good choice here.  To keep the FilterAttribute column consistent, I suggest you use a different column to control include or...

The *data* file drives should be 64K.  Log file drives should still be 4K.  If you mix data and log files on the same drive, you'll want to use 64K.

SELECT T3.SYMBOL,
T3.TRADE_DATE,
(AB30_C + AB30_P + AB30_G + AB30_R + AB30_Y) / NULLIF(SUM(CASE WHEN AB30_C = 0 THEN 0 ELSE 1 END + CASE WHEN AB30_P = 0...

I would think you would want four ids:

drive full path (other than drive, of course) filename extension

When new data comes in, you'd pre-add any new ids before loading the...

I would think you would want four ids:

drive

full path (other than drive, of course)

filename

extension

When new data comes in, you'd pre-add any new ids before loading the main table.  That way...

Somewhat confusing, the right join looks odd, but, anyway, you might try this and see if it produces the result you need:

;WITH DUniques AS (
  ...

You've got some choices, some more annoying than others:

(1) Use an INSERT trigger to check for dups and cancel if a dup would be created.

(2) Create additional columns that are...

That's somewhat confusing.  Do you want to not allow mixed case at all?  Or do you just want to prevent a duplicate from being inserted, basically ignoring case in determining...

;WITH Cte_Persons AS (
    SELECT *, ROW_NUMBER() OVER(PARTITION BY Name ORDER BY Id) AS Row_Num
    FROM @TBLPERSON
)
SELECT
    Name,
...

You can't use declared RI, but you could write your own.

As to the design, I assume the EntityIDs of the various tables -- Person, Service, Organisation, etc. -- overlap.  That's...

I think my code would adjust as follows to check program_date for inclusion:

SELECT ca1.*
FROM dbo.cust_sales_temp cst
CROSS APPLY ...
FROM (
    SELECT month#, sales, ROW_NUMBER() OVER(ORDER...

SELECT ca1.*
FROM dbo.cust_sales_temp cst
CROSS APPLY (
    SELECT cst.customer_id, cst.program_date, 
        MAX(CASE WHEN row_num = 1 THEN sales...

Recursion is notoriously slow for iteration.  Maybe use a "standard" tally table instead:

;WITH
cte_tally10 AS (
    SELECT * FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS numbers(number)
),
cte_tally100 AS (
 ...

CREATE VIEW must be in a batch by itself, i.e., without GOs, you could create only one view per script.

Since GOs are likely not valid, that may be what you...

In this case it doesn't.  But what is the harm in CASTing?