SqlServer行转列

STUFF替换第一个逗号为空。SELECTSTUFF((SELECT ','+CONVERT(NVARCHAR(20),S.ModelScenarioUID)FROM enstep.DealModelScenarios sINNER JOIN enstep.DealModelScenarioTypes dt ON dt.ScenarioTypeUID = s.ScenarioTypeUIDWHER

LtMamba

182人浏览 · 2021-10-29 09:50:44

LtMamba · 2021-10-29 09:50:44 发布

STUFF替换第一个逗号为空。
SELECT
STUFF(
(select
',1,
2'
)
,1,1,'')


SELECT
STUFF(
(SELECT ','+CONVERT(NVARCHAR(20),S.ModelScenarioUID)
FROM enstep.DealModelScenarios s
INNER JOIN enstep.DealModelScenarioTypes dt ON dt.ScenarioTypeUID = s.ScenarioTypeUID 
WHERE dt.ScenarioType='EOD-Official' AND dt.OfficialFlag='Y' AND s.InactiveFlag='N' AND s.CurveDate>=@CurveDate 
FOR xml path('')
)
,1,1,'')