In the end I changed the functions I was cross applying to NOT be inline functions. This means that the initial dataset (small) is brought back first and then the...

Yes I have a maximum of about 10 rows, that I need to cross apply to functions. I know whether the functions will return rows or not before they get...

This is a very old post. But not one that I think should be allowed to die.

There has been a lot of discussion of 13 vs 1. Personally my uninformed...

some timings... rough as I don't have a dedicated server to play with and only used one set of data.

Solution by G2

640

"Segment Top" solution

750

Cross apply solution

733

Solution by Flo

563

Flo's solution was...

I'd like a First() function in SQL server, often I need to get a value from a row that has been replicated by a join to another table. I know...