AWS isn't cheap. We should all be spending more on it. After all, Jeff Bezos has a rocket to fund, and apparently getting to space isn't cheap either. ??

Just wrap the whole thing  in a NOT:

WHERE NOT (
    [BillingReason] IN (1, 2, 3)
    AND [NewInsID] IS NOT NULL
 ...

Assuming the stored procedures contain no dynamic SQL, you shouldn't need EXECUTE AS for this at all.

If RO and dbo are both owned by dbo, SQL Server's ownership chaining allows...

In July 2023, I bought a 2.5-inch Samsung 870 EVO 4TB SSD for £150. The actual price was £199, but I received £50 cashback from Samsung, bringing the effective cost...

Does the table have any clustered index, e.g a clustered primary key?

As Scott points out moving the ON condition of a left join to the WHERE will make it an inner join.

But it is a good idea to try rewriting the...

I have a list of transactions in a table. Each transaction has a unique id which is a Guid, a date, a product that was ordered and an amount....

I have a list of transactions in a table. Each transaction has a unique id which is a Guid, a date, a product that was ordered and an amount....

You can export the data as text files as long as you re-import the files to check it goes smoothly. People often find commas in csv fields or...

How could I incorporate this into a report?

Can I add this to the bottom of the query?

IF OBJECT_ID('tempdb..#source_table', 'U') IS NOT NULL DROP TABLE #source_table;

IF OBJECT_ID('tempdb..##new_table', 'U') IS NOT...

if a global temp table works, that would be fantastic.  When, how does a global temp table get dropped.

P.S. I'm thinking of putting this code into a report, which...

This works using a global temporary table:

IF OBJECT_ID('tempdb..#source_table', 'U') IS NOT NULL DROP TABLE #source_table;
IF OBJECT_ID('tempdb..##new_table', 'U') IS NOT NULL DROP TABLE ##new_table;

DECLARE @sql NVARCHAR(MAX);
DECLARE @cols NVARCHAR(MAX);
DECLARE @insert_sql...

Error - Windowed functions cannot be used in the context of another windowed function or aggregate.

SELECT ROW_NUMBER() OVER (PARTITION BY Account ORDER BY A."Account") AS "RowNo", A."Account" AS "Account", (A."Debit")...

RIGHT_SHIFT and LEFT_SHIFT are CPU instructions implemented in hardware using barrel shifters, making them extremely fast, significantly faster than multiplying or dividing by 2 raised to an integer power. However,...