Why bother with a CTE?

Just declare a table variable and use an INSERT VALUES clause and use that in the main insert block.

Declare @ing table (recp_id int,ing_name_id...

Looks like you need to go and look at your schema.

All that red underlines mean you don’t have the right table or columns in your query.

Go look at the tables...

CREATE VIEW DailyAccountBalances AS
SELECT
CONVERT(DATE, TransactionDate) AS Date,
SUM(CASE WHEN TransactionType = 'Opening Balance' THEN Amount ELSE 0 END) AS OpeningBalance,
SUM(CASE WHEN TransactionType = 'Closing Balance' THEN Amount ELSE...

DATE is a DATATYPE not a function.

I am guessing you want to convert a DATETIME into a DATE value so you need the CONVERT function

CONVERT(DATE,TransactionDate) AS [Date]

If not please detail...

Server is configured for Integrated authentication only

So you have it set to use WINDOWS only not WINDOWS and SQL.

Easy to solve,

Right Click on the server name in SSMS and do...

The CNAME should work for all scenarios as it's just a pointer to the true A or AAAA record in DNS.

What specifically isn't working when using the CNAME in the...

OK, so "nearly" is not exact, so nearly 14 could actually be 13, or it could be 15 or some other random number.

Please first count the number of databases you...

INIT

Specifies that all backup sets should be overwritten, but preserves the media header. If INIT is specified, any existing backup set on that device is overwritten, if conditions permit. By...

It can cause issues restoring depending on how you are doing your backups.

If each log backup is run to its own individual timestamped file (as per best practice) then you...

First I would check the maintenance plan itself, there may be a send mail task in the MP for on success/failure.

Secondly check for multiple steps, potentially you have a step...

Is the Azure source DB a moving, operational database or is it a completely read only static database?

A bacpac is only as good as the time it was created, if...

Are you connecting locally or are you actually crossing the network?

If so you're probably using named pipes rather than TCP IP

But to test TCP you need to be crossing the...

Firstly why was the database removed from the AOAG?

Where any transactions in flight into the database on the primary which may have not made it to the secondary while the...

The SQL Server Browser service will be the item which is allowing you to connect to the named instance on any port as that is what it is designed to...

@steve-2 / @Grant / @Webmaster

I guess you already know this, but the ASK site is broken at the moment as the license to the software looks to have expired.

Your License...