How to Resolve N'' Prefix in Stored Procedure Parameters in SQL Server

Retrieving Distinct Rows from a Table in SQL Server: A Solution Using Common Table Expressions (CTEs)