April 20, 2011 at 10:54 am
I have a lot of audit data. it has an originate date, and a change date, and i want to translate that to a from date and to date, with what the data looked like in between those dates.
So i need to find a way to somehow, grouping by person and conversation #, order them by date, and maybe number them in order.
Anyone know of a good way to do this?
So i would like:
seq# origindate changedate personid convers#
1 9/9/2010 1/21/2011 55555 23564
2 9/9/2010 2/15/2011 55555 23564
3 9/9/2010 3/07/2011 55555 23564
1 7/27/2010 1/05/2011 33333 54266
2 7/27/2010 1/05/2011 33333 54266
3 7/27/2010 1/05/2011 33333 54266
thanks so much for your help!
amy
April 20, 2011 at 11:01 am
This article should help you out: SQL Server Ranking Functions[/url]
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 20, 2011 at 11:05 am
thank you!!!
April 20, 2011 at 11:14 am
You're most welcome Amy.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply