If the number of rows in your source table is low ... in the tens of thousands, maybe ... a full refresh is simplest and cleanest.

As soon as the full...

The trigger/audit table solution sounds like the best fit to me. It's been done many times before and there are loads of articles around on this ... I think I've...

And they have been available since SS 2016.

The best method depends on what is driving the requirement. Is this for reporting, auditing or...

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

I used a script like this ...

Like what?

Regardless of the Intellisense comment, this shows, I think, that the problem lies with Apex auto-complete and not with SSMS, and therefore that you should consider contacting them for support....

That is unusual. If you turn off Apex SQL, does the behaviour continue?

A quick couple of comments.

IF OBJECT_ID('product') IS NOT NULL

DROP TABLE [dbo].[product]

May be replaced by DROP TABLE IF EXISTS [dbo].[product].

Not only that, but if you had a proc in the database...

I would like to update TASK_NXT_RUN_DT  column based on the script in column 2 dynamically. I have tried using while loop and dynamic sql but no luck. Any help...

Yes, change the precedence constraint from step 2 to step 3 to 'Completion'.

Just out of interest, can you explain how you intend to use the Sale table in the DW?

This feels like an excessive amount of de-normalisation to me.

Just to clarify, presumably this is for an OLTP system? If so, wouldn't this be a parameterised update, run from a proc?

Eg

Exec update_Sale @Item_Id, @Sale_Code

?

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

Before you go any further, make sure that you have your RTO and RPO defined and agreed by interested parties.

This information will feed into the choice you make. Though it...

I really need to learn to start with the KISS Principle, but sometimes it is hard for this old dog to learn better habits.

Thank you Phil for keeping me...

Thank you for the reply. The rows are linked, but I wouldn't necessarily say there is a child / parent relationship. As in there are children, but I'm not...

I just did a quick search on the topic and there is loads of material out there already, written by people more qualified than I.

But the answer I gleaned from...