How to separate values by stick when Feature values for C and X is dif

I work on SQL server 2012 I face issue : I can't get all different value Feature one one row result

separated by sticky if it multiple difference

if one different then no need stick.

where c have value and x have value but both not equal each other

so How can i do that Please ?

Expected Result :

Tall (80-20) | Weight(5-10) | Tall(190-130)

attached file :

http://www.mediafire.com/file/mxyr8wr9k98za7o/ExplainReport.xlsx/file

Firstly you need to use a Case statement like below. Ref link. https://www.w3schools.com/sql/sql_case.asp

SELECT *,

CASE WHEN (FeatureValueC is not null and FeatureValueX is not null) then

FeatureName +"("+ (cast as FeatureValueC varchar) + "-" + (cast as FeatureValueX varchar) +")"

END AS FeatureValue

FROM FeatureNameandValues;

Then you need to concat the FeatureValue using coalesce. Ref Link.

https://dba.stackexchange.com/questions/68089/how-to-use-coalesce-with-multiple-rows-and-without-preceding-comma

DECLARE @col nvarchar(MAX);

SELECT @col = COALESCE(@col + ' | ', '') + FeatureValue

FROM (SELECT *,

CASE WHEN (FeatureValueC is not null and FeatureValueX is not null) then

FeatureName +"("+ (cast as FeatureValueC varchar) + "-" + (cast as FeatureValueX varchar) +")"

END AS FeatureValue

FROM FeatureNameandValues) ainnertable;

@col will give the values seperated by |