Cannot necessarily comment on the good/bad aspect of the above, but I would be inclined to use named sets. See reference here: https://technet.microsoft.com/en-us/library/ms145487(v=sql.110).aspx