ETL

SQLServerCentral Article

The Art of Data Ingestion - Part 1

  • Article

Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? There is of course data exporting as well, and in that case, […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (8)

You rated this post out of 5. Change rating

2022-11-11

5,849 reads

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