Hi All,
Thanks for all the help I have since figured this out. Did a little tweaking with the sql and got it to stop looping and running up my temp database file.