password

create Proc PMP_GetLastThreePassword  --763,'ani763um'
@UserID int, 
@Password varchar(500) 
AS 
BEGIN 
 
  select COUNT(*) from
  (
 
  Select top 3 new_value,profile_id  From PMP_User_Profile_History where userid=@UserID
  and column_name='password'  order by profile_id desc 
  ) t where new_value = @Password
 

 
END