March 26, 2020 at 12:03 pm
How to separate value exist on temp table dynamically separated by comma ?
problem
How to separate value exist on temp table dynamically separated by comma ?
i work on sql server 2012 i need to separate field TeamName by comma
teamname ,teamname+'Date'
i need to loop to teamname filed in tmp table #Teams then separate by comma and every field will be next field + 'Date'
really #temp table #teams every time changed so i dont have static data so i need any way dynamically sepatae field
and second will be field+date
CREATE TABLE #Teams
(
TeamId int,
TeamName nvarchar(200)
)
insert into #Teams(TeamId,TeamName)
values
(1,'Package'),
(2,'Parametric'),
(3,'Scribing'),
(4,'Lifecycle')
i need result as
Package,PackageDate,Parametric,ParametricDate,Scribing,ScribingDate,Lifecycle,LifecycleDate
March 26, 2020 at 1:24 pm
select string_agg(concat(TeamName, ',', concat(TeamName, 'Date')), ',') from #Teams;
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
March 26, 2020 at 1:26 pm
O the question is for 2012. Sorry, it needs the xml trick. The above is 2017+
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
March 26, 2020 at 1:55 pm
select stuff((select concat(' ', TeamName, ',', concat(TeamName, 'Date'))
from #Teams for xml path ('')), 1, 1, '');
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy