Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Do you know anyone Scottish?

with 2 comments

Here’s something fun to show them:
  1. Open SQL Server Management Studio
  2. Connect to the AdventureWorks cube
  3. Run the following query:
    select [Measures].[Internet Sales Amount]
    on 0,
    on 1
    from [Adventure Works]
  4. Scroll down the result set and point out that according to AdventureWorks, Scotland is a city in England.


Written by Chris Webb

November 24, 2005 at 5:13 pm

Posted in Off-topic

2 Responses

Subscribe to comments with RSS.

  1. Chris, thank you for catching this mistake. We\’ll be sure to get it fixed for SP1. -rob


    November 28, 2005 at 10:53 pm

  2. I am Scottish, and I find this very offensive.


    December 1, 2005 at 2:51 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 3,963 other followers

%d bloggers like this: