Hello Brian,

This table has data about 200K and 20 columns. daily changed may be around 100 new records and changes about 100 to 200 records for few columns.

there is only...

Hello David.

Can you please provide any example with this

Thank you

asita

Thanks PietLinden.

I can do that Individual updates for each column as Des mentioned. how to capture the LastRecordModifiedDate column values (sorry not part of original Question).

so this LastRecordModifiedDate need to...

Thank you DesNorton,

I got that, my question was how can I incorporate that in this single statement, that null values update always need to check for all columns, if source...

Good Evening,

Here in this process, how do we check to make sure we are not updating target with the source null values (when target has a value already) also only...

Thank you Jeffery,

Can you please give one sample with couple records. much helpful. with the join and CTE..

Thank you

Asiti

Thank you for your inputs I apologize for my mistake in my sample the last case statement is 9. not 0.

Thank you for all your assistance and guidance

I would like to see if any other alternatives were there. other than Case.. Please

Thank you

Sure Jeff. Will provide shortly, I am preparing it. Thank you in advance.

Thank you Much Phil.

Hello Jeff,

Can you please help with it in the way you advised in SQL SERVER.

https://www.sqlservercentral.com/forums/topic/how-to-insert-data-to-target-table-when-there-is-no-matching-and-update-if-has#post-3888376

Thank you

ASiti

Thank you Phil. Sure I will follow your guidelines and mindful next time when I Do

Thanks

Asiti

this is the new post can you please help with it if possible

Thank you

ASita

Thank you DesNorton.

Can you give some guide lines... how to validate (better ones may be try_convert or ISDate or some other efficient way before loading to intermediately table) and load...

Apologize Phil.

I posted in the other post first but realized it is not the correct place for it as that is discussion not relate to Coding perspective. so I then...