From: Alan on 6 Dec 2009 22:07 Sorry for the delay in responding: Raw data set looks like (compressed): DT Temp Seq 08:00:01 27 2 08:00:02 29 2 08:00:03 31 3 08:00:04 33 3 08:00:05 35 4 08:00:06 32 2 08:00:07 31 3 08:00:08 32 3 08:00:09 34 4 The result set I want looks like: 08:00:05 25 4 08:00:09 25 4 Thanks again TheSQLGuru wrote: How about a table with some test data and expected outcome(s)?? 26-Nov-09 How about a table with some test data and expected outcome(s)?? Not quite following the verbal description, and test data with outcomes would allow for proper solution development. -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice Silverlight Multipurpose WebRequest Proxy http://www.eggheadcafe.com/tutorials/aspnet/45d1dc2b-7db7-4bbc-b612-003fe889ed4a/silverlight-multipurpose.aspx
|
Pages: 1 Prev: Lock_timeout with ADO.NET? Next: Create Adjancency Model From Flat Data? |