title: TSQL: Why cannot use newid() inside a scalar-valued function
body: <p>I try to implement the following link with a scalar-valued function, the SQL Server 2000 return an error msg: Invalid use of <strong>'newid'</strong> within a function.</p>
  
  <p><a href="http://www.bennadel.com/blog/310-Ask-Ben-Getting-A-Random-Date-From-A-Date-Range-In-SQL.htm" rel="nofollow noreferrer">http://www.bennadel.com/blog/310-Ask-Ben-Getting-A-Random-Date-From-A-Date-Range-In-SQL.htm</a></p>
  
  <p>Is there any way to get around this?</p>