Yep that's what I ended up having to do and it works but this is going to be a sp that will be called by an asp page so I am kind of worried about requests hitting at the same time but for now it allows me to finsh up other parts and I can revisit this to see if there is any better way to do it.