I see I posted this under the wrong forum -- the solution only need apply to SQL Server 2008 R2 or higher.
As for the "why", this is a data collection/troubleshooting stored procedure that will run on our clients' servers. Since I don't have access to their hardware I want the lookup to be dynamic.