Distinct column names from comma separated string

Distinct column names from comma separated string

pTwo reports are using columns of a table with following queries/p
precodeSELECT [Employee Name] , [Email_ID] , [Region] , [DOB] , [Joining
Date] , [Gross Salary] FROM [tblC6FD_Data_15_EmployeeData] ORDER BY
[Employee Name] ASC, [Email_ID] ASC, [Region] ASC, [DOB] ASC, [Joining
Date] ASC, [Gross Salary] ASC /code/pre hr precodeSELECT [Employee Name] ,
[Region] , [Email_ID] , [DOB] , [Leaving Date] , [Basic Salary] FROM
[tblC6FD_Data_15_EmployeeData] ORDER BY [Employee Name] ASC, [Region] ASC,
[Email_ID] ASC, [DOB] ASC, [Joining Date] ASC, [Gross Salary] ASC
/code/pre pand i want distinct columns list of table that is being used by
reports/p pstrongExpected output/strong/p precodeEmployee Email Region DOB
Joining Date Gross Salary Leaving Date Basic Salary /code/pre pI have one
idea to split it with code,/code but a lot of confusions and complexity to
avoid other strings after strongfrom/strong keyword./p pCan anyone suggest
a simple solution./p