Assuming you delete/append once per day, can you truncate the table if today is the 1st of August? This is set to truncate on the 2nd of July for testing....

You should be able to use MAX CASE() to pivot the columns assuming there are no duplicates of ID and TYPE.

What do you want to see for missing values? This...

I don't know what settings would help, but have you looked at the aggregation design recently? If many users are running the same reports regularly it may be possible to...

<Deleted incorrect information suggesting columns can be added to existing tables within a stored procedure.>

Variables can not be...

• This reply was modified 6 months, 3 weeks ago by  Ed B. Reason: Removed bad information

I don't think you have a choice. I believe the truncate needs...

Is the data in your sqlToExec column in a format that will work with dynamic sql? It looks like might not be so you will probably need to at least...

I think your code will set the @SQLString variable to the value of the last row in the batch. If you want to execute multiple rows in a single SP_EXECUTESQL...

Did you try using a variable...

Does it make any difference if you make the data flow source a variable set to an expression that includes the date variable? The example below uses a MinDate string...

I've always thought you should only use inner join if you want to return columns from the other table, but this link suggests join is preferable if there is an...

I have not used ADF, but I did a quick search and it sounds like the error tasks will only execute if both of the preceding tasks fail. In SSIS...

This link makes it sound like you can install the native client if you have apps that require it. https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver15

I tried but could not get Visual Studio 2017...

Try this

Select * from T1 
Join T2  on T2.activity LIKE CONCAT('%',left(T1.activity, len(T1.activity)-1),'%')

Does this work for the first example? I have assumed you need to group by company and trade_date.

;
WITH cte_L 
AS
(
    SELECT *,
  ...

• This reply was modified 9 months ago by  Ed B. Reason: Added T

Does this work?

'INSERT INTO DBO.DataTable
SELECT *, NULL, ''N'' AS PROCESSED_FLAG
FROM #TEMP_TABLE'

If you use a column list for the insert and select you can exclude processed_date and it...