From: Alan on
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