Les Smith

I am a database developer working with SQL Server and Oracle8i. My focus is on data warehousing, reporting and analysis. The tools I use are Java, Stored Procedures, Visual Basic and commercial applications such as Informatica. I am currently working at an Application Service Provider company in Silicon Valley.

SQLServerCentral Article

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,237 reads

Blogs

Daily Coping 31 Jan 2023

By

Today’s coping tip is to take a small step towards and important goal. One...

Tales From The Field Weekly Wrap Up for the Week of 01-23-2022

By

 Hello Dear Reader!  It's been a while since I had time to sit down...

CONCAT_WS Function Truncates Text

By

I was writing some dynamic SQL that generates some SQL statements to load my...

Read the latest Blogs

Forums

The Data Fabric – Future of Data Management

By Ajay Kumar

Comments posted to this topic are about the item The Data Fabric – Future...

The Rise of Vector Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Rise of Vector Databases

Backup Permissions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backup Permissions

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers