am reusit sa-l fac astfel....cu un cursor:

declare @SerialNumber nvarchar(50),@Product nvarchar(50),
        @Phase nvarchar(50),@ComponentSerialNumber nvarchar(50)

DECLARE pers CURSOR FOR
 select Product,SerialNumber,Phase,ComponentSerialNumber from HiperPL  where Phase = 'W' 
 GROUP By Product,SerialNumber,Phase,ComponentSerialNumber

OPEN pers

FETCH NEXT FROM pers
INTO @Product,@SerialNumber,@Phase,@ComponentSerialNumber

WHILE @@FETCH_STATUS = 0
BEGIN

 select Product,Phase,SerialNumber,ComponentSerialNumber from HiperPL
  WHERE Product=@Product AND SerialNumber=@SerialNumber
     AND ComponentSerialNumber <> (SELECT TOP 1 ComponentSerialNumber FROM HiperPL
              where Product=@Product AND SerialNumber=@SerialNumber AND Phase=@Phase order by ActivatingTime desc)
 order by Product

FETCH NEXT FROM pers
INTO @Product,@SerialNumber,@Phase,@ComponentSerialNumber
END

CLOSE pers
DEALLOCATE pers

functioneza f bine....problema acum e ca dureaza f mult.......as putea sa transform acest cursor intr-un simplu SELECT?....cum ar putea arata asta