OK, I think I understand. Would this work for you?

SELECT DISTINCT A.FirstName, A.LastName, A.DepartmentName, A.Title, A.StartDate, A.EndDate,

CASE WHEN ISNULL(A.EndDate, '01/01/1900') <> ISNULL(B.EndDate, '01/01/1900')

THEN 'Y'

ELSE 'N' END AS...

Wow, that's almost not worth it. Nice.

duplicate thread, see:

http://www.sqlservercentral.com/Forums/Topic1276726-1633-1.aspx

I said split mistakenly, you were correct to use join.

I see no expressions posted with Join.

However, this is something I have used from a multi valued parameter for column visibility...

I am a bit confused. In your initial question you talked about 3 levels of grouping. I don't see data that would have 3 levels of grouping in...

Yes, I said SPLIT instead of JOIN. You are correct to use join.

Please post your entire expression.

Is your parameter a multi-value parameter? If it is not, you should not be using the (0) or the (1). If it is, you should use SPLIT to...

In the immortal words of Uniblab (is my age showing?)

Back to work (click), back to work (click). Everybody (click) work work work work (click) work work (click)!"

You should be able to use a Row_Number or Rank function in your SQL to order your data and build your conditional visibility.

I wrote a blog on using Row_Number to...

That looks like it should work. What is the error you are getting?

Which value would you like to be visible?

Post vacation blahs

I have following conditions to meet initially.

1. Records will only be created for those recrods if the group has 'C' in IsgroupCorrected.

so I am using conditional spilit to...

You add a derived column transformation to your data flow. Using the column where the data is too long create a new column with a meaningful name (I always...

There may be several ways to get the data. Does Google Analytics have a web service of some sort you can connect to with SOAP, or download flat or...