anthony.green (4/30/2012)

---

can you please post the create table statements for each table, will hopefully help us understand a bit more to whats going on

also are BFlights and Transactions in the...

That's my mistake when removing the dbo's before I copied the SQL. I still get that error.

I think I've found the answer:

SELECT Dimensions.Stores.Store

, Dimensions.Stores.StoreCode

, Dimensions.Regions.Region

, COUNT(Transactions.TransactionID) AS CountOfTransactions

FROM ...

This seems to work:

SELECT DISTINCT

...

Yes and no.

I'll try to explain. The way our sales process works after a marketing campaign is like this:

Campaign is sent out to multiple entities(essentially a different tables...

Thanks, That seems a very obvious answer once I read it. D'oh! Which leads me to see a fatal floor in my plan and subsequently onto my next question....