2021-04-28
467 reads
Tyler
2021-03-24
143 reads
2020-11-18
395 reads
2020-11-04
423 reads
2020-10-28
520 reads
2020-10-21
512 reads
2020-10-07
467 reads
2020-09-23
400 reads
2020-09-16
405 reads
2020-04-23
828 reads
Blogs
Grinding Away: Brent Ozar
By Steve Jones
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...
Monday Monitor Tips: Am I Patched?
By Steve Jones
One of the things that I think is neat is that Redgate Monitor helps...
Big Queries, Big Money
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
Forums
Download Aol Desktop Gold +1 (858) 333 4611 Install Aol Desktop Gold or Update
AOL Desktop Gold Download+1 (858) 333 4611 : A Step-by-Step Guide AOL Desktop Gold...
Peer review SQL Central articles
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Getting ANY of the data
Comments posted to this topic are about the item Getting ANY of the data
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 12What 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