THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql » puzzle » t-sql tuesday   (RSS)
Sorry, but there are no more tags available to filter with.
  • T-SQL Tuesday - HAVING Puzzle answer

    Earlier today you may have seen a blog post of mine about a puzzle involving HAVING. You should read that post before this one. It was part of Adam Machanic’s T-SQL Tuesday meme. The question was about the query: SELECT 'No Rows' WHERE 1=2 HAVING 1=1; And here’s the explanation. Start by making yourself a "dual table", like ...
    Posted to Rob Farley (Weblog) by rob_farley on January 12, 2010
  • T-SQL Tuesday - T-SQL Puzzle with HAVING

    (Reposted from my msmvps.com blog) Adam’s hosting another T-SQL Tuesday, for which this post is jumping in. He’s themed it around T-SQL Puzzles, which I found quite interesting, because the world is full of them. Most of the questions that I answer on forums, help sites, and so on, are puzzles. I guess there’s the difference between “Problem” ...
    Posted to Rob Farley (Weblog) by rob_farley on January 11, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement