ChrisM@Work (2/10/2016)
GilaMonster (2/10/2016)
ChrisM@Work (2/10/2016)
and it would have met Gail's precautionary restrictions too.My comments had nothing to do with what the function returns, rather where to use it (not in a DML statement affecting more than a couple of rows)
My comment was also where to use it: "returning the result to a variable".
Insufficient coffee error. 🙁
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability