Hi Gail,

I have attached the create script for dbo.Name

Thanks Jacob, that worked.

I also tried this way and it worked as well, just FYI.

Select * from activity where product_code like '%WELL%' and transaction_date between '2013-01-01' and '2014-12-31'

Thanks again.

SQLisAwE5OmE (12/30/2015)

---

Not after I modified the script as Alan mentioned as below.

SELECT DISTINCT females_only.*

From dbo.vw_csys_NurserySchool

Cross Apply (

SELECT Parent1_id, Parent1_FullName, Parent1_Email, Parent1_STATUS, Parent1_Gender, YEAR, FULL_ADDRESS

WHERE Parent1_Gender = 'F'

UNION ALL

SELECT Parent2_id, Parent2_FullName,...

Okay, Thanks for your inputs. Appreciate it.

Jeff Moden (12/30/2015)

---

SQLisAwE5OmE (12/30/2015)

---

I tried to include the CATEGORY field to the script Jeff provided and it seems working, but my only concern is, this doesn't pull the parent2 field....as...

I tried to include the CATEGORY field to the script Jeff provided and it seems working, but my only concern is, this doesn't pull the parent2 field....as my original script....so,...

ScottPletcher (12/30/2015)

---

SELECT DISTINCT females_only.*

From dbo.vw_csys_NurserySchool

Cross Apply (

SELECT Parent1_id, Parent1_FullName, Parent1_Email, Parent1_STATUS, Parent1_Gender, YEAR, FULL_ADDRESS

WHERE Parent1_Gender = 'F' AND CATEGORY <> 'STF'

UNION

SELECT Parent2_id, Parent2_FullName, Parent2_Email, Parent2_STATUS, Parent2_Gender,YEAR, FULL_ADDRESS

WHERE Parent2_Gender = 'F'...

SQLisAwE5OmE (12/30/2015)

---

Not after I modified the script as Alan mentioned as below.

SELECT DISTINCT females_only.*

From dbo.vw_csys_NurserySchool

Cross Apply (

SELECT Parent1_id, Parent1_FullName, Parent1_Email, Parent1_STATUS, Parent1_Gender, YEAR, FULL_ADDRESS

WHERE Parent1_Gender = 'F'

UNION ALL

SELECT Parent2_id, Parent2_FullName,...

Not after I modified the script as Alan mentioned as below.

SELECT DISTINCT females_only.*

From dbo.vw_csys_NurserySchool

Cross Apply (

SELECT Parent1_id, Parent1_FullName, Parent1_Email, Parent1_STATUS, Parent1_Gender, YEAR, FULL_ADDRESS

WHERE Parent1_Gender = 'F'

UNION ALL

SELECT Parent2_id, Parent2_FullName, Parent2_Email,...

Jeff Moden (12/29/2015)

---

Thanks for that. That view is a bit of a "Rosetta Stone" for what the table...

Jeff, See the attachment for the create view script. Thanks.

Thnx again Jeff for trying. I am learning.

I am really sorry Jacob. Thank you!....that seems working now.

SELECT DISTINCT females_only.*

From dbo.vw_csys_NurserySchool

Cross Apply (

SELECT Parent1_id, Parent1_FullName, Parent1_Email, Parent1_STATUS, Parent1_Gender, YEAR, FULL_ADDRESS

WHERE Parent1_Gender = 'F'

UNION ALL

SELECT Parent2_id, Parent2_FullName,...

Yes, I tried with distinct as I mentioned earlier, but still duplicates shows.

Unless I am inserting distinct at wrong place. See below

Select females_only.*

From dbo.vw_csys_NurserySchool

Cross Apply (

SELECT distinct Parent1_id, Parent1_FullName,...

Thanks Scott, it still gives duplicates even after changing as you mentioned.

Anyway, thank you, at least I've got the list, I will export to excel and remove duplicates.

Thank you again...