Can you please provide more inputs on the same.
1. What is your SP doing.
2. If possible, please provide SP script.
3. Your question with expected resultset.
ALTER PROCEDURE [dbo].[proc_PDC_CDC_Dynamic_Generate_CSV_Table]
@Condition varchar(50),
@userid ...