Selecting Rows where hourly data changed

I have a table that contains hourly data of several different categories that is collected every hour by a separate software package. This table contains a timestamp,name, and value for several objects in several categories. For one particular category of data, the hourly values, do not change too often. I cannot figure out how to select in this particular category the first timestamp where the name and value are distinct.

   SELECT DISINCT NAME,VALUE ........ I have tried several different things and the query either hangs up or gives me bogus results.

Thanks for the help.

Renee Tumbleson
tumblesonr_at_firstenergycorp.com Received on Mon Jul 23 2001 - 12:05:53 CDT