What sort of 'updates' do you need to look for? INSERTS, UPDATES and/or DELETES?

Do your tables have DateCreated and DateModified columns? If they do, this exercise probably becomes easier and...

Yes. You've been here long enough to know this.

Please provide sample DDL, INSERT statements with test data and desired output based on the data provided.

Just extend what you are already doing

Select * from
(
 SELECT Stuff.Example1
Stuff.Example2
Stuff.Example3
Stuff.Example4
 FROM   Table1) As FirstSet
 INNER JOIN
 (
  SELECT This.Example5
 This.Example6
 This.Example7
 This.Example8
 FROM...

• This reply was modified 5 years, 8 months ago by Phil Parkin.
• This reply was modified 5 years, 8 months ago by Phil Parkin.

SELECT TOP (1) DateTime, 
TOC = value
FROM runtime.dbo.History
WHERE TagName = 'WFI_LP01_TOC.PV'
AND DateTime >= '2018-01-01'
AND DateTime <= '2018-01-08'
AND wwRetrievalMode = 'Cyclic'
ORDER BY value desc

So you want the TOC column to show the same value for all the rows within the selected range?

• This reply was modified 5 years, 8 months ago by Phil Parkin.

Where in the process is the value being set to NULL? The source, somewhere in the data flow, or at the destination? (I suggest you use a Data Viewer if...

In our project, we use this tool to frequently promote SSIS project builds from  DEV ->TEST and further environments.

Hence, it would be a bit challenging to migrate the historical...

Interesting, I had no idea that this tool even existed!

Does it also migrate the run history? (That is, the information displayed on the All Executions report.) If migrating from one...

And then spent hours creating an exploding RBAR GIF, I seem to remember!

• This reply was modified 5 years, 8 months ago by Phil Parkin.

I know he's clever, but still probably prefers to be called Brian 🙂

I presume you've got a lot of this to do & you want to build an automated way of doing it.

The way I've approached tasks like this in the past...

The problem (as far as I can see), is knowing the value of PK_POSTE so that you can INSERT the FK rows in Params_Poste, is that right?

If so, SCOPE_IDENTITY()...

• This reply was modified 5 years, 8 months ago by Phil Parkin. Reason: Fix small typos in code

The...

It looks to me as though this statement

INSERT INTO Postes (NAME_POSTE)
VALUES (@NamePoste)

will fail, because you have not provided a value for PK_POSTE.

QUESTION: why do some queries work on older Compatibility level than the new? i thought microsoft made the Cardinality Estimator better in the new 2012+ versions? or maybe an update...