Daniel Janik

Daniel Janik has been supporting SQL Server for 18 years as a DBA, developer, architect, and consultant. He spent six years at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has spoken at several SQL Saturday events across the US and Caribbean and regularly speaks at PASS local chapters.

Blogs

Grinding Away: Brent Ozar

By

Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...

Monday Monitor Tips: Am I Patched?

By

One of the things that I think is neat is that Redgate Monitor helps...

Big Queries, Big Money

By

I had been meaning to post this, so as I finished a piece that...

Read the latest Blogs

Forums

Download Aol Desktop Gold +1 (858) 333 4611 Install Aol Desktop Gold or Update

By showjohn41

AOL Desktop Gold Download+1 (858) 333 4611 : A Step-by-Step Guide AOL Desktop Gold...

Peer review SQL Central articles

By Srinivasarao Daruna

Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...

Getting ANY of the data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting ANY of the data

Visit the forum

Question of the Day

Getting ANY of the data

I have this data in two tables:

-- Beer table
BeerIDBeerNamebrewer
5Becks    Interbrew
6Fat Tire   New Belgium
7Mac n Jacks  Mac & Jack's Brewery
8Alaskan AmberAlaskan Brewing 
9Kirin        Kirin Brewing

-- Beercount table
BeerName      BottleCount
Becks         5
Fat Tire      1
Mac n Jacks   2
Alaskan Amber 4
NULL          7
Corona        2
Tsing Tao     4
Kirin         12
What is returned from this query?
SELECT *
FROM dbo.BeerCount AS bc
WHERE bc.BeerName=ANY
  (SELECT b2.BeerName FROM dbo.Beer AS b2);
 

See possible answers