palotaiarpad (2/24/2016)

---

select

r.ID, r.FULL_NAME, r.FULL_ADDRESS,r.MEMBER_TYPE, r.BIRTH_DATE,

CONVERT (int,DATEDIFF(hour,r.BIRTH_DATE,GETDATE())/8766)as Age,

r.Parent1_FullName,r.Parent1_Cell,r.Parent1_Email,

r.Parent2_FullName,r.Parent2_Cell,r.Parent2_Email

from IMIS.dbo.vw_csys_registrations r

WHERE r.MEETING_TYPE='PADA' and r.MEMBER_TYPE LIKE '%CH'

intersect

select

r.ID, r.FULL_NAME, r.FULL_ADDRESS,r.MEMBER_TYPE, r.BIRTH_DATE,

CONVERT (int,DATEDIFF(hour,r.BIRTH_DATE,GETDATE())/8766)as Age,

r.Parent1_FullName,r.Parent1_Cell,r.Parent1_Email,

r.Parent2_FullName,r.Parent2_Cell,r.Parent2_Email

from IMIS.dbo.vw_csys_registrations r

WHERE r.MEETING_TYPE='TSM' and r.MEMBER_TYPE LIKE...

ScottPletcher (2/23/2016)

---

SELECT

r.ID, r.FULL_NAME, r.FULL_ADDRESS,r.MEMBER_TYPE, r.BIRTH_DATE,

CONVERT (int,DATEDIFF(hour,r.BIRTH_DATE,GETDATE())/8766)as Age,r.MEETING_TYPE,r.MEETING,r.TITLE,

r.Parent1_FullName,r.Parent1_Cell,r.Parent1_Email,

r.Parent2_FullName,r.Parent2_Cell,r.Parent2_Email

FROM (

SELECT r2.ID

FROM IMIS.dbo.vw_csys_registrations r2

WHERE r2.MEETING_TYPE in ('PADA', 'TSM') AND r2.MEMBER_TYPE...

Thank you djj. I modified the query and got the results. I have about 49 unique students registered to both music and dance. Appreciate your help.

WITH cte1...

Sean Lange (2/4/2016)

---

SQLisAwE5OmE (2/4/2016)

---

Sean Lange (2/4/2016)

---

SQLisAwE5OmE (2/4/2016)

---

Hi Sean,

I tried your query, and I am getting the following error.

Msg 4104, Level 16, State 1, Line 43

The multi-part identifier "pa.ParentID" could not...

Sean Lange (2/4/2016)

---

SQLisAwE5OmE (2/4/2016)

---

Hi Sean,

I tried your query, and I am getting the following error.

Msg 4104, Level 16, State 1, Line 43

The multi-part identifier "pa.ParentID" could not be bound.

Msg 207,...

Sean Lange (1/25/2016)

---

SQLisAwE5OmE (1/25/2016)

---

INNER join is fine at the parent info....

I am confused whats the exact syntax to use under group by clause.

Basically I need to find out if a...

Sean Lange (1/25/2016)

---

SQLisAwE5OmE (1/25/2016)

---

INNER join is fine at the parent info....

I am confused whats the exact syntax to use under group by clause.

Basically I need to find out if a...

INNER join is fine at the parent info....

I am confused whats the exact syntax to use under group by clause.

Basically I need to find out if a student is registered...

Sean Lange (1/25/2016)

---

SQLisAwE5OmE (1/25/2016)

---

Hi Sean, Thanks for the feedback.

Sorry for the messy query....I didn't actually write it.....I wish I could write query like that....but thanks for cleaning it up.

Anyway, I...

Hi Sean, Thanks for the feedback.

Sorry for the messy query....I didn't actually write it.....I wish I could write query like that....but thanks for cleaning it up.

Anyway, I use crystal reports...

Hi Drew,

I didn't get the groupby caluse....can you put it in...

ScottPletcher (1/11/2016)

---

SQLisAwE5OmE (1/11/2016)

---

ScottPletcher (1/11/2016)

---

I would think it would be something like below.

Note: I assumed from the context that you need to match only the *child's* birthday, even though you said...

J Livingston SQL (1/11/2016)

---

is there any reason why you cannot / will not provide sample data for your table?

am sure it will make providing you a tested solution so much...

ScottPletcher (1/11/2016)

---

I would think it would be something like below.

Note: I assumed from the context that you need to match only the *child's* birthday, even though you said "all members"....

Sean Lange (1/11/2016)

---

You desperately need to do some reading about database design and normalization. This table is a mess and appear to be lacking any attempt at normalization.

As to...