I beg to differ. Recursion (in T-SQL) is always worse than a while loop!...

Ed W. (11/24/2008)

---

Ok, so you populated a table with numbers. Everyone can argue about how to do that, but the real question is what do you DO with the table...

Joe Celko (11/24/2008)

---

Here is another method, which uses a tale of digits and some math

CREATE TABLE Sequence (seq INTEGER NOT NULL PRIMARY KEY);

WITH Digits (i)

AS

(VALUES (0), (1), (2),...

Sorry,...

CheeseMan316 (11/24/2008)

---

Adam...

Just throw the CTE into an inline TVF. In my tests it almost always performs equally fast, and sometimes is even faster, than using a table.

Not only is the feature deprecated, but barely anyone used TEXTPTRs anyway 🙂

By the way, when I saw "text data pointer" I thought the question was talking about the 24...

As others have mentioned, a sort is not the only option, and the NULL may or may not come first... No one actually showed this yet, though, so here you...

Just to clarify this...

Just keep thanking your lucky stars that they didn't choose EF... Here's a thread someone sent me yesterday...

Timothy (9/22/2008)

---

I'm just curious, how would you expect any object relational mapper to handle the case of varying results from a procedure? What kind of result type would you expect...

Exactly; doing that work would defeat the whole purpose of LINQ....

Timothy (9/22/2008)

---

Unless I'm missing...

Matt Miller (9/22/2008)

---

The overhead I'm talking about is comparing LINQ-enabled perf vs not. From what I can tell - there's a non-negligible perf penalty, just by adding in LINQ....

Matt Miller (9/22/2008)

---

If you're going to encapsulate your data calls in a "true" DAL - what advantage do you get out of LINQ? Why not finish encapsulating the calls...