October 18, 2010 at 11:23 am
Does anybody have any challenging sql problems/puzzles...
Or if you know any sites would be helpful
October 18, 2010 at 1:15 pm
QotD on this site has plenty of them. Here is the link.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 19, 2010 at 2:37 pm
http://beyondrelational.com/quiz/sqlserver/general/2010/default.aspx is having a whole month of difficult challenges beyond the scope of writing queries.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 21, 2010 at 2:27 am
Thank you , Pradeep
October 21, 2010 at 2:29 am
thanks a lot, Seane
October 22, 2010 at 3:27 pm
CELKO (10/22/2010)
Shameless plug for my SQL Puzzles & Answers bookhttp://www.elsevierdirect.com/product.jsp?isbn=9780123735966
Joe,
I actually went to this site to check out what was in the book. The TOC gives a high-level by the name of the puzzles - but is there anywhere that goes into a little more detail about what the puzzle is solving, from a more sql technical point-of-view? Some of those, you just can't tell what you're actually trying to do from the name of the puzzle.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply