The Club info is in that table (or View)

The attribute.PersonMembership is the one with the invoices (membership info)

It is showing but showing 2014 and 2015.

It should show 2015 AND a null row like ClubNo 8004

So neither solutions are showing ClubNo 5305 null row like ClubNo 8004.

Only difference...

Thank you both ...

however ...

ChrisM@Work,

yours is showing 2014.

and both are not showing ClubNo 5305 with a null membership info like ClubNo 8004.

NOTE: 5305 has memberships in 2015 and prior years.

8004...

I will try this.

Yes, all memberships that end on 6/30 of any given year.

Need to see all Clubs memberships ending on 6/30

of current year (2015) or next year (2016)...

I will try this.

As for the date range

Need to see all Clubs memberships ending on 6/30

of current year (2015) or next year (2016) when the MemberTypeID = 1, 2,...

For anyone else needing a solution

Got this to save as a SQL View thanks to Brian

NOTE: the ColName fields must be the same data type.

WITH Base AS

(SELECT RowNum, TeamID,...

Thank you very much!

that worked!

I see the stored procedure now.

spTeamCoachPivot

I did do the

exec dbo.spTeamCoachPivot and am able to see the results in the SQL View.

However I can't save the...

yes, it's saved as a .sql (script)?

not sure really how to do much of this in SQL

Newbie :unsure:

So close.

Found info and got this far with a stored prodecure

DECLARE @sql nvarchar(max)

SET @sql = N'SELECT TeamID'

SELECT @sql = @sql + ',MAX(CASE...

I don't. I used the title that the link I found I posted states.

Just went with it.

I know that in Access you can do first or last as Value in...

Yes, in the sense, MAX is in fact Aggregating. I think it's because of WHAT you can do with it is why it's looked at / considered as "not" really...

gbritton1 (8/15/2014)

---

This is not working since you are using column names in the Pivot ON:

PIVOT (max(TeamId) FOR PersonId IN ([CoachFN], [CoachLN], [CoachEmail])) pvt

should be:

PIVOT (max(TeamId) FOR PersonId IN (PER00388878, PER00500029,PER00530907,...

Ok

NOTE: i provided code that's sort of working

with the data set (though just a few records)

as well as the current output.

I thought that was enough information?

1) sample data set

2) explanation...

lol, 'tis true ... report requesters

I did see the concat option, unfortunately she does not want it in one field.

JeeTee (8/15/2014)

---

If MemberTypeID 2 is all you care about, you can simply omit the lines of code from Eirikurs example that reference MemberTypeIDs you don't care about.

Is this for a...