Hi Hilary,
I am sure this post has been locked and finished as it was opened in 2009 however I still find it very useful and trying to incorporate steps being advised. I have created the Stored procs. however when executing "GenerateGUID" it returns GUIDE as below:
GUID
3107A100-F109-4668-973F-3692B67D15BD
However Return Value is ...