使用视图或函数重用sql

I have a sql query that I will be reusing in multiple stored procedures. The query works against multiple tables and returns an integer value based on 2 variables passed to it.I have a sql query that I will be reusing in mu