Is the description of the problem not clear or the problem not that easy to solve?

Any help appreciated,

Thanks.

Thank you both, just what I need.

Thanks both for the sql code.

Peter SQL code is what I need from my request and the other SQL code can be used for my test data generating scrip.

Is...

Both SQL codes work perfectly!

Thanks Peter Brinkhaus and ChrisM@home

Your correct about the database design but I was asked to use ssis (so the bad design continues) so any guidance on how to go about it in ssis would...

Thank you both Matthew Darwin and HanShi you sql code helped me out. I simply add the 'AND' to the case statement to ResponseDate and Response columns.

Thank!!

Thank you! That's perfect

The Event_Role column contains both the parent and the child hierarchies which are -

Parent (level 1)

Participant_ID

Supporter_id

Event_code

Event_role

Child (level 2)

Do not register

No Reg

Yes Reg

Child Level3

Did Not Attend

Yes Attend

This possible because the Supporter_ID...

Wanted results something like below -

INSERT INTO Wanted results (Participant_ID,supporter_id,event_code,Event_role,Lv2 child,Lv3 child) VALUES ('234221','98130','BALL05','NULL','Do not register','Did Not Attend');

INSERT INTO Wanted results (Participant_ID,supporter_id,event_code,Event_role,Lv2 child,Lv3 child) VALUES ('234222','98130','BCC07','NULL','No Reg','Did Not Attend');

INSERT INTO...

Thanks c_o! it works perfectly 😀

just a a few simply questions relating to my actual table which contains 200000+ rows and additional columns I did not include in the sample...

I would prefer to change the schema now. How would I go about doing that?

Thank you!

Thanks c_o, for helping out.

the SQL code works perfectly!!

Do you know how to create a hierarchy group from the event_roles?

Thanks again.

Hopefully the scrip I created below is more helpful. It creates the sample data and the wanted results also in another table. See scrip below.

Thanks

CREATE TABLE [dbo].[table1](

Participant_ID [int]...

Thanks for your response apologise for the last post I had no idea about what I was trying to do. Hopefully the second post from me is more helpful to...

Thank You For the Comprehensive Reply!!!

Can you help me with one more question releating to folders and Variables?

Is there any way to retrieve the folder name for example...