Geeks With Blogs
An educated guess (Timur Fanshteyn) Technology, Software Development and other ways to make an educated guess about the world... April 2008 Entries
SQL ROW_NUMBER() function and Audit tables
I had to search through an audit table to find times when the value changes in a specific field. Considering an audit table DateModified DateTime ID varchar() Quantity decimal Price decimal I wanted to find the rows when Quantity changed for the same ID. I've been able to accomplish that using the ROW_NUMBER function of SQL 2005 Here's the query: select Row_Number() OVER (PARTITION BY ID Order BY ID, DateModified) as RowID, DateModified, Quantity, ID INTO #TempData from AuditTable select a.ID, b.DateModified, ......

Posted On Thursday, April 10, 2008 6:16 AM

Yuneta's Blog
A friend of mine started a blog and started posting nice support entries. http://yunetasblog.blogspot... Technorati Tags: Blogs, Tips CrossPosted from http://blog.tfanshteyn.com ......

Posted On Thursday, April 10, 2008 6:15 AM

Copyright © Timur Fanshteyn | Powered by: GeeksWithBlogs.net | Join free