I don't mean to waste your time, but I have googled this and a variety of other strings and have not been able to find anything of value.

Ok so, I thought it was working however I keep getting this error for the below code...

ERROR:

The name "ID" is not permitted in this context. Valid expressions are constants, constant...

Haha thanks mate. That helped a lot.

P.S. I am a finance recruitment officer by day... I seem to structure all of my questions as though I am interviewing someone.

Hi mate,

I have the following which is closer then what I had when I first posted... It still is not working though... It comes up with the error:

Msg 207,...