The variables after the create statement are input parameters. The user will call the procedure with values assigned to these parameters which are then passed to your query to help return results specific to the values the user seeks.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events