Oops, my bad....

Conceptually and in principle, Functions, especially "true" functions (no-side effects) are...

Heh. OK, it's far harder for *most* of us to find and validate working Urdu. 🙂

Jeff Moden (8/14/2009)

---

RBarryYoung (8/11/2009)

---

Nah, that's me. Jeff hates the term "pseudo-cursor" and...

Wayne: Any chance we could get some Create Table defs & sample data Inserts?

You have to try to use up some of the bad squares first before everything becomes forced:

X - A2

O - B1

X - B3

O - C1

X - A1 (must block)

O...

A function is possible but a recursive function is not recommended. If really you wanted to do a function then I would recommend that it be written to wrap...

Hmm, sorry. I will try to test and fix it tonight.

To summarize what I think that we all agree on: What you have is fine and there is no apparent reason to change it.

I thought that too, but I've always seen CAS exceptions indicated somewhere in the error messages.

Thanks, Steve, but I'd rather not add any fuel to this particular fire. 😉

Jeff Moden (8/13/2009)

---

You've mistaken what I said but, looking back at it, I can see how. I put no words in your mouth or at least I didn't mean...

Jeff Moden (8/13/2009)

---

...

If I may, there are another couple of things to consider here... I don't believe the likes of Grant Fritchey, Gail Shaw, Barry Young, Lynn Pettis, Jack Corbett,...

Steve Jones - Editor (8/13/2009)

---

...As far as the forums, I'm not sure how easy this is to do, or how wide/narrow I'd want it. The thing that concerns me about...

Well both Functions and INSERT..EXEC have a lot of restrictions on them. So many in fact that AFAIK, you cannot use INSERT_EXEC in a user-defined function, because:

- INSERT..EXEC...