Hi I have this code in c# and I want to convert this to T-SQL and put in stored proc. I'm having a problem in speed as I am processing more than 50000 records at a time and the Update statement slows it down. I was thinking stored procedure could help on my problem. Thanks in advance.
Here's what I have: