Paul White (3/14/2010)
(though it is a shame that NEWID is illegal in a function):
Old gaming advice... if you can't move forward, backward, left, right, up, down, then change "color". 😉
You can access a VIEW from a UDF. One like the following allows for the use of NEWID() in a function... Same goes for GETDATE() and a couple of other things you supposedly can't use in a UDF.
CREATE VIEW MyNewID
AS
SELECT NEWID() AS ANewID
--Jeff Moden
Change is inevitable... Change for the better is not.