SQL Stored Procedure Performance is bad

Transact-SQL
1

I have a SP in a job which is performing slowwww. I identified that the SP which is the culprit, Need some help in identifying the root cause.

------ SP:

2

Cursors are notoriously slow. You need to get rid of cursors where possible and use set-based logic instead.

3

Hi @ScottPletcher ,

Thanks for the input, Can you please provide an example or modify a part of the SP using set-based logic.

Thanks