# dbt-sqlserver 1.7.2 incremental model adding existing records with different version

**URL:** <https://discourse.getdbt.com/t/dbt-sqlserver-1-7-2-incremental-model-adding-existing-records-with-different-version/12105>\
**Category:** Help\
**Tags:** incremental, dbt-core\
**Created:** [February 18, 2024, 11:47am UTC](https://discourse.getdbt.com/t/dbt-sqlserver-1-7-2-incremental-model-adding-existing-records-with-different-version/12105 "2024-02-18T11:47:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![maki.markie](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@maki.markie](https://discourse.getdbt.com/u/maki.markie)\
**Post date:** [February 18, 2024, 11:47am UTC](https://discourse.getdbt.com/t/dbt-sqlserver-1-7-2-incremental-model-adding-existing-records-with-different-version/12105/1 "2024-02-18T11:47:13Z")

</div>

## The problem I’m having

creating a incremental model that appends records to the target table and if they exists then update the version\_number + 1 without deleting the existing records for this date

## The context of why I’m trying to do this

because i want to see the history of the given date what is changed on this given referenced date. If I already have records on the target table lets say on 2024-02-18 with version==1

Then I would like to append the incoming records on the same date but with max(version) + 1

Thanks a lot, maki.markie