OK, that's what it looked like but it appears *not useful*. Why use a filter, only to use AND in front of it, and make the usage of a...

in Eirikur's example the LEFT JOIN with the AND returns everything.

In the Adventureworks example:

The LEFT JOIN with the WHERE returns 9 records.

The LEFT JOIN with the AND returns...

our communal downlevel was blown away yesterday so am re - importing the flat files to sql before can use this info.

Heartened by all the support. Can't wait to make...

Awesome! I'm on the logical path. That's what I needed, because I was totally not sure about how to properly address this.

OK. The key here is you're telling me that indexing is how I solve this particular ETL problem.

Thanks and I'm on my way to reading all about and implementing...

ok, I forgot to mention, I have definitely created indexes. This was necessary so that I could even run them as TOP 1000 queries. They are as follows....

This is literally the query: 7 JOINS and millions of rows.

--KEYWORDS

SELECT TOP 1000

publisher_name as account,

reverse(left(reverse(publisher_name),(charindex('-',reverse(publisher_name),0))-2)) as publisher,

C.campaign_id,

channel_bing_pixel = CASE WHEN D.dimension_name = 'Channel_Bing_Pixel' then value END,

google_conversion_label =...

Dead of night and must cook up an 11 yr old's birthday party...hours from now will assess and report back to you, Lynn. Appreciate it, very much.

thank you Chris!

;with cte as

(

select message_id,

count(message_id) over (partition by message_id) as NoSent

from messagesSent

)

Select

message_id,

case when NoSent =...

Thanks very much for engaging with me.

CROSS JOIN is a possible way of doing it. I tried that and it was a performance KILLER when I had lots of properties.

Here's what I ended up doing:

I...

Yes, a right join to a calendar table will create nulls for property_name column on days no activity occurred. how about i full outer joined to property activity table on...

Regarding LAG() you might have thought to ask if I was even using sql server 2012...which im not. Ours is still 2008r2. Ofcourse I came for help. Thanks.

Cool. Thanks for sharing the alternatives to an SSRS solution (SSRS forum, ahem).

Yes, very cool. Thanks for sharing.