Payback... just couldn't resist. 😛

Loops, by their very nature, process things Row-By-Agonizing-Row. SQL is a set-based language, and thus performs best with set-based code.

If you provide the DDL scripts (CREATE TABLE, CREATE INDEX, etc.)...

Nugby (2/22/2010)

---

Sorry, the Function produces Fund Manager Information, e.g. Manager Name, Portfolios, Securities, Net Asset Values etc. It's table-based as you can therefore imagine.

...

To reiterate, can someone can confirm...

Fixed that for you, Paul. 😀

... but seriously, Thanks!

RBarryYoung (2/22/2010)

---

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one...

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

You don't mention if:

1. What the function returns (datatype), and

2. Whether this is a table-valued function, or a scalar-valued function.

So, assuming that this is a table-valued function that returns a...

Paul White (2/22/2010)

---

The updated test data setup script is in...

Nope... Gus seems to be the type that would have the code finish 'bout the time the weekend...

reidres (2/22/2010)

---

Jeff,

I don't want people on my team optimizing for trivial things, and the constraints of the project define those things. Speed may not be essential, or it may....

If you use sp_executesql, the dynamic string can be set up so that all variables are parameters, and the parameters also passed in thru sp_executesql. As you add/drop lines in...

I think you want to change your INNER JOIN to a CROSS JOIN (which means remove the...

like this... you don't need to cast ROW_NUMBER to an int... it already is

select top 100

case

when ROW_NUMBER() over...

SOM! :w00t:

Well??? Haven't you had enough time to think...