Yes, you can use Always Encrypted.  Please see here.

John

You need to use OPENQUERY or a linked server or SSIS or something like that to grab the data from Excel.  What you're trying to do is convert the actual...

sp_executesql is a stored procedure.  You can't use it in the middle of a SELECT statement.  Like I said: table DDL and sample data, please, otherwise it's just too difficult...

This will get you the statement(s)
SELECT [SELECT] + ' WHERE ' + [WHERE] + ' ORDER ' + [ORDER] = '; SELECT @@ROWCOUNT AS RecordCount;'
FROM YourTableofQueries

Have you tried using Powershell instead of VB?

John

Indeed it doesn't - that's how SQL Server works.  It grabs all the memory it needs (up to the max server memory) and doesn't give it back until the operating...

What else are you going to use the memory for?  If the 200GB that is used for the load isn't used during the day, it'll soon get overwritten in memory...

Alex

T-SQL probably isn't the best tool for this job, but that doesn't mean it can't be done.

DECLARE @String varchar(max) = 'Do this to <variable1.544>...

Why not set it up so that the ones that are going to cause errors are excluded from your list?

DECLARE @sql varchar(max);
SET @sql = (

Then you need ORDER BY Line, not ServiceDay, in your OVER clause.

John

Since you're using the same temp table whichever branch of the IF you go along, why not just create it at the beginning, outside the IF logic?

You need...

BEGIN needs to come immediately after IF or ELSE IF, and the corresponding END needs to come right at the end or immediately before the next ELSE IF.  Hope that...