I have this SQL below that pull all data from a table:
select * from SRV_CLASS_detail order by SRV_CLASS_ID;
You will have a sample of the table in the attachment.
as you will see, in the table, i have 2 columns for the OPEN Time and CLOSED time and 7 columns for the days.
I would like to extract from the table in a specific format.
In the excel attachment, when you will look into sheet: Result from new SQL, you will see that i'm putting the open and closed time inder the day's opened.
N = Not opened
Y = Opened
It should only put the time Under opened days.
How can i do this.
Thanks for your help