» T-SQL Tuesday
» sql (RSS)
Sorry, but there are no more tags available to filter with.
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'
HAVING 1=1; And here’s the explanation.
Start by making yourself a "dual table", like ...
(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” ...