Thank you all. I can now see how I may be able to return the data I need to avoid dynamic SQL. And I also learned...

yes, I have. I think Functions disallow the use of stored procedures in it. I used dynamic because I want to evaluate the week number if it is...