This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Many of us use auto-increment primary keys in our tables, but these PK's don't exist in the raw data as a natural key. So when we get new raw data, we cannot use the Update / Insert if New method which keys off the Primary Key.
Imagine if you could select ANY unique key on the table instead?
There's no reason not to allow this from a SQL perspective, though it might be a little less efficient for some DB engines. But it would make things so much easier!!!
Right now, I instead load to a temp holding table and then do deletes and inserts using the Post Create SQL statement.