GilaMonster (2/10/2016)
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 - I'm far more familiar with this error than you are!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden