The question is a little vague. If I understand, I recommend checking out derived tables. The derived table is simply another select statement that can use parms...