Jeff Moden (6/11/2010)

---

I don't like those challenges because they teach the wrong thing. There are many times where the resolution of a problem using a single query is just...

SSIS may be a better fit for this, though you can probably set the permission level to 'external' , assuming this is CLR.

Sounds like it could be recompiling , check with profiler

Is this even sqlServer ? Decode is not a sqlserver function

Please post DDL etc as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Best advice would be to get SQL2008 internals

http://www.amazon.co.uk/Microsoft-SQL-Server-2008-Internals/dp/0735626243

best guess..

this...

from Players Join Brands on PlayerID

should be

from Players Join Brands on Players.PlayerID = Brands.PlayerId

HTH

Feeling the SSC love in the forum today 🙂

Maddy , maybe my response to you was a little terse. Im glad to see that you mistaking my sig for an...

No, i wont. It is trivial. Read Books On Line for 30seconds and you will see...

Investigate the row_number() function

I find intellisense and its most annoying when putting together test code , ie where im quite happy for a column called 'A','B' or 'ID'. Can never remember to...

Cross Post , please keep to one thread

http://www.sqlservercentral.com/Forums/FindPost928725.aspx

I have to echo Gianluca, this is crazy. What are you expecting and wanting to achieve.

The next SqlBits hasn't been announced yet, there are number of UserGroups.

See this page http://www.sqlserverfaq.com/%5B/url%5D

Then you may as well not do any performance testing , it will have...