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

Variables can not be...

• This reply was modified 1 year, 3 months 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 to use...

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 1 year, 5 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...

I assume the source file does not contain a processed_flag or processed_date column. I just ran a quick bulk insert test and when I added an extra column to the...

I would look at some tutorials and script it yourself. This link has an example of a partition scheme based on months, but it would be easy to modify for...

Do either of these give you what you need?

--ONE ROW PER NAME WITH COUNT
SELECT firstlastmerged,
       COUNT(firstlastmerged) AS Cnt
FROM   dbo.YourTable
GROUP...