Returning first row in a table for multiple items...

[Yammyguy]

Hello all,

 

I'm stuck on a query.  Basically, I would like to return the FIRST row for each item selected that match the criteria specified.

 

For example, I have 73 names, and I would like to return the first row for each name from a table that match my criteria...

 

here's the code I've got so far...

 

SELECT TOP 1 d.DEVICE_NAME, lpd.INTERVAL_DATE
FROM LOAD_PROFILE_DETAILS AS lpd
INNER JOIN DEVICES AS d ON (lpd.DEVICE_ID = d.DEVICE_ID)
WHERE d.DEVICE_ID IN (
SELECT DEVICE_ID FROM DEVICES
WHERE DEVICE_NAME LIKE 'KWH%'
AND PROVISION_STATUS = 2
) 
AND  lpd.RAW_LOAD_VALUE > 0

 

I'm not getting any errors, but the query will run for ever.

Any help would be greatly appreciated!

 

Thanks very much in advance!