Hi Steve - Here are the choices

Create a new View

Use a cursor and store the data in a temporary table

Create an Indexed View

Create a User Defined Function to return the needed data

Create a new Table