declare @SerialNumber nvarchar(50),@Product nvarchar(50)
set @SerialNumber = 'M04'
set @Product = 'CR'
select Product,Phase,SerialNumber,ComponentSerialNumber from HiperPL where SerialNumber = @SerialNumber and Product=@Product
  and ComponentSerialNumber <>(Select ComponentSerialNumber from HiperPL where SerialNumber = @SerialNumber and Phase = 'W'
  and  Product = @Product )
order by Product

cam asta as vrea sa-mi faca doar ca fara sa-i definesc eu variabilele....daca ii definesc eu variabilele ca mai sus e simplu.....dar vreau sa-mi faca pt toate Product si pt toate SerialNumber din tabela respectiva