Something like this may work:

with base as (
select
  rn = row_number() over (partition by Account order by Sharetype asc)
  , Account
  ,...

This is almost the exact same query from another post, it just has a DISTINCT TOP (1) added to it.

Good luck on this one: https://www.sqlservercentral.com/Forums/1914001/viewstablesstored-procedures-are-rolled-back-to-previous-versions.

Have you seen his next question?
https://www.sqlservercentral.com/Forums/Topic1913979.aspx

I stand corrected, I got to the end of code and found why it is dynamic SQL, your ORDER BY clause can use a different column on each instantiation of...

This snippet doesn't even make sense:
AND (NOT EXISTS (SELECT 1 FROM @SampleStatusId) OR samp.SampleCondition IN (SELECT id FROM @SampleStatusId))

EDIT: Nevermind, it does now.

Second, why are you using dynamic SQL inside the stored procedure?  I am not seeing ANY reason for dynamic SQL to be used.  I am seeing a lot a poor...

First, why are you executing the stored procedure using dynamic SQL?