Pritz (3/14/2014)
got this error:Windowed functions can only appear in the SELECT or ORDER BY clauses.
First, for what code. Posting "got this error" really doesn't tell anyone anything.
Second, recheck the previous posts, you will find I corrected my code.