Sql

Question

How to get comma less value in MS Sql ID Name Location 1 Ram 1234

Avinash Vajpayee · Answer

declare @commasepvalue varchar(50)='12345' select q2.value from (SELECT cast(' '+replace(@commasepvalue''' ')+' ' as xml) as thexml)q1 CROSS APPLY (SELECT x.value('.''varchar(100)') as value FROM thexml.nodes('x') as f(x))q2 answer i found

Avinash Vajpayee · Answer

declare @commasepvalue varchar(50)='12345' select q2.value from (SELECT cast(' '+replace(@commasepvalue''' ')+' ' as xml) as thexml)q1 CROSS APPLY (SELECT x.value('.''varchar(100)') as value FROM thexml.nodes('x') as f(x))q2

Ajay Gupta · Answer

SELECT A.Id AS [ID]A.Name AS [Name] A.Location AS [Location] FROM TableName T CROSS APPLY (SELECT * FROM [CSVToTableWithID](T.ID T.NameT.Location)) A

Avinash Vajpayee · Answer

Location Column Value in temp table column Location 1 2 3 4

Manas Mohapatra · Answer

What exactly output do you want?