Thank you very much!

that worked!

I see the stored procedure now.

spTeamCoachPivot

I did do the

exec dbo.spTeamCoachPivot and am able to see the results in the SQL View.

However I can't save the View to be used for other views/reports?

I am getting:

Incorrect syntax near the keyword 'Exec'.

After trying to save the View (vTeamCoachesPivot)

Need to save the view to use the results to do an INNER JOIN in another view (pull the names linked to the PersonId columns

End goal is to get all of the Coach Names (based on PersonId per Team (TeamId))

then link that view with these results to the Competitions the Teams and Coaches were/are involved in for the Event's manager.