Hi,
I can't find anything decent online to help me out in finding how I could convert my following static sql pivot script into a dynamic pivot :
with cte as (SELECT ppl.name,
ppl.surname,
ppl.phone,
pos.positionName,
com.companyName,
ts.tagName,
'TagName' + CONVERT(varchar(250),ROW_NUMBER()...