please read and follow the instructions in the first article I reference below in my signature block regarding asking for help. It will walk you through what you need to post and how to do it to get the best answers possible.

From the descriptiong, it looks like you are using cursors and/or loops where a set-based alternative may be better.

We can't tell until we see your code.