I found the problem, it was an infinite loop I forgot to take the @ away from a variable, which was actually a field name.

Thanks for all the help you...

Hi Matt,

Thanks for your help, if it was up to me I wouldn't even do this in the DB, I would do it in the app, but alas.

I PMed you...

Thanks you guys for all the answers let me clarify a bit more.

I have a table variable where this information goes into but I need some conditional information, yes this...