Resolved the issue in TSQL using the CTE.

Thanks everyone for your suggestion and help 🙂

Thanks for the help everyone 🙂

Below is the updated INSERT statement

Thanks.

--Insert some sampele data

INSERT INTO dbo.Flights(

FLIGHT_PATH_START

...

Please let me know if this helps in little bit of clarification.

USe MyDb

--Create Table scripts

CREATE TABLE dbo.Flights

(

[FLIGHT_PATH_START] [varchar](3) NULL,

[FLIGHT_PATH_END] [varchar](3) NULL,

[STOPS] [int] NULL,

[FLIGHT_1_OPERATING_DAY] [int] NULL,

[FLIGHT_1_OPERATING_DAY] [int]...

Sorry, if my post looks weired. I was looking to get the CSV seperated values or seperated by '\' for the 'Day of the Week' column...based on the distinct...