I always use the list provided by SSC.  Just search "20xx Build List"

Check out the ROW_NUMBER() function in BOL

check out this article:

https://blogs.msdn.microsoft.com/alwaysonpro/2014/01/30/setting-up-replication-on-a-database-that-is-part-of-an-alwayson-availability-group/

Actually, I think the problem is your dynamic SQL doesn't recognize the variable (@Loop)
[code language="SELECT @cmd = 'use AEC_BPCS; IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE Type...

So your code now looks like this?:
[code language="SELECT @cmd = 'use AEC_BPCS IF EXISTS (SELECT 1 FROM sys.objects WHERE Type = ''U''' +
    'AND name = '''...

Remove the single quote around @Loop = @Loop + 1

AND name = ''' + @TB + ''') BEGIN SET '@Loop = @Loop + 1' END' + ' ELSE '+

What is the source of data for this table?  Look at INSERT BULK

replace(cast(FORMAT(cast(Column1 as float), '### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ### | ###...

I'm not fond of the static years in this code.  Perhaps it could be converted to a dynamic pivot
declare @t table (    
    startdate date,
    enddate date
)

Trust is a hard thing to get back once it's lost.  If I were given the freedom to try, I'd start with a handful of smaller "wins".  If that doesn't...

In our case, we have two databases on the same instance.  DB1 has encrypted data.  DB2 accesses DB1 data via a view.  The above code allowed for the retrieval of...

if your database has already been restored you should be able
OPEN MASTER KEY DECRYPTION...

select
    OrderID,
    Items,
    GroupID,
    RunningTotalInGroup,
    SUM(IncrBasket) OVER(ORDER BY groupID ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as BasketID
from (
    select
        OrderID,
        Items,
        GroupID,
        case lag(groupid) over (order...

If you've got the default trace running and it hasn't rolled off yet, it might give you what you're looking for:

SELECT i.*
FROM sys.traces T
CROSS Apply ::fn_trace_gettable(T.path,...