Thanks Dave for your suggestions.

I believe that this solutions will work out well.

It is assumed that the columns listed in the predicate are unqiue.

ie.

[Table A].Col1 = ColA1

...

yes my mistake. Truncate vs delete..Guess you are right 🙂

Thanks

Thanks Grasshopper for the input. Indeed the system is already in production. Hence would need to opt for an alternative solution...

Prefer not to include an association between tables and the temp tables.

Would like to avoid changes in schema plus the temp table is just a temporary persisted table. This...

Thanks for your feedback stewartc-708166.

I believe that the problem with the suggested approach is that there is no means how to relate TableX with #Temp.

With the aim to explain my...

@celko. I would keep the null dates as nulls and exclude them from the query.

Then use...

From first looks I would try to avoid dynamic SQL and the where 1=1 looks inappropriate.

Thank you for this great article.

I am migrating my skills from relational database development to dimensional modeling. The transition is slightly non straightforward since I have been working with...