How to replace sub string by stuff separated by stick | to separate values?

Question

How to replace sub string by stuff separated by stick | to separate values?

ahmed salah 3,216

I work on SQL server 2012 I face issue I can't separate values by stick | using stuff ?

meaning i need to replace sub string by stuff

and what statement below do as sub string ,type.value and XML path

SELECT DISTINCT
[InputID],PART_ID,[Vendor ID],Manufacturer,[Digi-Key Part No.] ,[Mfr Part No.],[Description],Category,Family ,Obsolete ,[Non-Stock]
, [Part_Status],partNumber,CompanyName,DKFeatureName2,[Variant Number],IsUnit,
SUBSTRING((

SELECT isnull(StarFormat,'') + Value+ isnull(endFormat,'')
FROM #FinalTable
WHERE ([InputID] = Results.[InputID] and DkFeatureId = Results.DkFeatureId)
FOR XML PATH(''),TYPE).value('.', 'NVARCHAR(MAX)')
,1,5000) AS Value
FROM #FinalTable Results
where StatusId=3

Yitzhak Khabinsky 26,586 Reputation points

2020-08-24T03:03:41.197+00:00

@ahmed salah , you already posted few questions here on the forum.

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in #1 above.
(4) Your SQL Server version (SELECT @@version;)

4 answers

Your answer

Yitzhak Khabinsky 26,586 Reputation points

2020-08-24T03:03:41.197+00:00

@ahmed salah , you already posted few questions here on the forum.

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in #1 above.
(4) Your SQL Server version (SELECT @@version;)