Browse by Tags

• Prime number challenge
• T-SQL

• The prime number challenge – great waste of time!

  No sane person would even consider using SQL Server to construct a list of prime numbers. So just to prove that I’m not sane (as if there could be any doubt!), this post will be about finding prime numbers. First a bit of history. Ward Pond wrote about Read More... Posted Saturday, September 23, 2006 10:54 PM by Hugo Kornelis | 9 Comments Filed under: Performance, Prime number challenge, Tricks, T-SQL

• Relating unrelated rows

  A recurring question in the newsgroups is: “How do I output unrelated rows side by side?” I’ll use the AdventureWorks database as an example. Suppose that my manager wants a report listing, for each order, all products ordered and all reasons the customer Read More... Posted Friday, July 14, 2006 10:23 PM by Hugo Kornelis | 3 Comments Filed under: Performance, Tricks, T-SQL