stored procedure in sql server

stored procedure in sql server

  
Hi,
I need to know how to send an atributte with a value in a advanced query to a stored procedure and manipulate them inn the sql server procedure. It´s possible?

Best Regards