compare one column values with same column values of data in sql server?

See more:

SQL-Server

ALTER proc [dbo].[K_RT_GetRatebasedonmeat]
@partyname int,
@meattype int
as

begin


select case when PE.meattype<>(select meattype from K_RT_PartyNameYearly where partyname=@partyname) then 0  else isnull(PE.rateperkg,0) end as rateperkg from K_RT_PartyNameYearly PE
 inner join K_RT_PartyName PN on PE.partysno=PN.sno where PE.partysno=@partyname and PE.meattype=@meattype
 end

I wrote like this for my requirement but its not working properly. When i pass partyname and meattype as parameters, If "K_RT_PartyNameYearly" this table does not contain meattype for that partyname at that time I want to show 0 value.How can i write please help me.