Chris Cathers

  • Interests: SQL, Of course, & Programing, writing, and reviewiong missions for the Video Game Operation FlashPoint.

SQLServerCentral Article

Custom String Functions

SQL Server's Data Transformation Services (DTS) is a fantastic tool for importing data from any type of source. However even with this tool, you sometimes need more flexibility than it appears to have, especially if the data formats are unknown far enough in advance. New author Chris Cathers has developed a technique that allows him to be extremely flexible without causing too many headaches down the road.

You rated this post out of 5. Change rating

2004-10-18

9,504 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