Les Smith

Data Warehouse Version Management

In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.

2001-08-27

3,159 reads

Blogs

Daily Coping 2 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting

By

Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...

MVP for Another Year 2020-2021

By

Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...

Read the latest Blogs

Forums

Daily Coping 2 Jul 2020

By Steve Jones - SSC Editor

Today’s tip is share a happy memory with someone who means a lot to...

Query taking more than 4 hrs. - Any recommendations/suggestions?

By Feivel

One of our stored procs has been running for more than 4 hrs. and...

Unusual use of the WHERE clause

By michael.leach2015

I am working an exercise problem where the solution provided has a WHERE clause...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers