Thanks for everyone who helped, I finally got it working just before end of the day yesterday.
Just one more question, does anyone know the syntax to use this in a view?
I have:
CREATE VIEW view_name
As
Declare..........
....................
This is where my code starts, but it says incorrect syntax near Declare.