DML

SELECT U.Name,

U.Value

FROM (

SELECT C1Count = COUNT(ASCII(C1)),

...

Tom.Thomson (4/8/2010)

---

This explanation is wrong. The IsNull function converts to the type...

I'm going to try to find a little time tonight to knock the handshake thing up in a CLR routine - it's a lot easier to write the m-from-n requirement...

Lynn Pettis (4/8/2010)

---

I rewrote your MLTVF as an in-line TVF last night and was testing it against your scalar function and it was still slower, approx 3 seconds vs approx...

Garadin (4/8/2010)

---

As far as I know, the only criteria for an INLINE TVF vs a MLTVF is that it has to be all one statement. IE. Begins with WITH...

I agree 🙂

Question: (and I wouldn't have even asked it if I hadn't read this first) is what is the point in...

Cool - they are essentially the same method - assign a random value to each distinct group, and sort by that first. The only bit of trickery in my...

I'm sure you will find a way to do this - I had a crack at the handshaking thing because it was in terms I could understand (!) and seemed...

vk-kirov (4/8/2010)

---

I vote for this list: SQRT, LOG, LOG10,...

The fast query plan file is damaged - you seem to have performed multiple search-and-replace operations on the XML - for example 'Ca' was replaced with 'USA'. Unintended replacements...

You're welcome, Andrew. Thanks again for the poster 😎

Tom.Thomson (4/8/2010)

---

:w00t:

Would work for me except that that NOT gets in the way;-). And you've copied my slip of the pen (PRINT instead of SELECT):blush:. And I'm not...

DECLARE @Example

TABLE (

franchise_id INTEGER NOT NULL,

sector_id ...

Scalar T-SQL functions suck.

Multi-statement T-SQL functions suck more.

In-line T-SQL functions are awesome.

Multi-statement functions do have their uses - but only if the logic cannot be written in a single SELECT,...