sgmunson (8/19/2015)

---

Okay, now that I've had a chance to consume the data that JLivingstonSQL posted that appears to be the same data that was in the Access database you posted,...

serviceaellis (8/19/2015)

---

J Livingston SQL (8/19/2015)

---

as a starter....does this get you the required results....??

DECLARE @yr AS int;

SET @yr = 2015;

WITH cteclub

AS (

SELECT DISTINCT

...

J Livingston SQL (8/19/2015)

---

as a starter....does this get you the required results....??

DECLARE @yr AS int;

SET @yr = 2015;

WITH cteclub

AS (

SELECT DISTINCT

...

Ugh, just realized that the DECLARE states only 2015.

I changed it to 2016 and is in fact seeing 5305 with NULL values in the membership fields.

What I was looking for....

got on to the SQL Server.

ok, so another way to explain what I've been trying to state, think I'm saying the same thing though ...

need current and future years AND...

ChrisM@home (8/19/2015)

---

Please run this and report back with the results:

SELECT * FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)

Let's try this again. Run this query:

SELECT ClubID FROM dbo.v060ClubOfficersPresOrNot WHERE ClubID IN (5305,8004)

Do...

Sorry, I thought if you click Reply on the Post...

Club information WITHOUT membership information.

Which should but then also include membership information IF it exists BUT still produce the Club information

The excel file was included in the .zip uploaded yesterday.

Here's the image with several columns hidden so it can be seen easier.

Without any modifications to the original formula I get...

Ah, thank you

The RDP access to the SQL Server is not responding at the moment.

But from what I can gather from the formula,

it'll produce the 15 memberships ending on 6/30/2015 for ClubNo...

ChrisM@Works,

The columns except the last four columns which are:

MembershipTypeIdEndDateInvoiceNumberPersonMembership_PersonId

Please see attached.

The worksheet is the result that needs to be produced with the highlighted row.

in the Access file the two tables are:

1. PersonMembership - with all the membership info

2....

Interesting someone came up with this, which shows the NULL memberships for these clubs BUT I'm missing the 15 memberships for the clubno 5305.

Can't seem to get the 15 membership...

Thank you! it works!

Yay!