Exactly how did you test that?

The comment found in the code of an old stored procedure states the following:

--Using dynamic SQL (faster than static SQL for large tables)


To add to the confusion, the procedure neither had dynamic SQL nor returned more than one record.