摘要：将多个字段按固定间隔拼接为新字段，统一使用NVARCHAR(10)格式并用'-'连接。

SQL字段拼接优化

      在SQL查询中，为了统一字段格式并实现拼接功能，可以采用以下方法：

CAST(f.Segment2 AS NVARCHAR(10)) + '-' + CAST(f.Segment12 AS NVARCHAR(10)) + '-' + CAST(f.Segment22 AS NVARCHAR(10)) AS 部门,
CAST(f.Segment3 AS NVARCHAR(10)) + '-' + CAST(f.Segment13 AS NVARCHAR(10)) + '-' + CAST(f.Segment23 AS NVARCHAR(10)) AS 客户,
CAST(f.Segment4 AS NVARCHAR(10)) + '-' + CAST(f.Segment14 AS NVARCHAR(10)) + '-' + CAST(f.Segment24 AS NVARCHAR(10)) AS 供应商,
CAST(f.Segment5 AS NVARCHAR(10)) + '-' + CAST(f.Segment15 AS NVARCHAR(10)) + '-' + CAST(f.Segment25 AS NVARCHAR(10)) AS 银行,
CAST(f.Segment6 AS NVARCHAR(10)) + '-' + CAST(f.Segment16 AS NVARCHAR(10)) + '-' + CAST(f.Segment26 AS NVARCHAR(10)) AS 员工,
CAST(f.Segment7 AS NVARCHAR(10)) + '-' + CAST(f.Segment17 AS NVARCHAR(10)) + '-' + CAST(f.Segment27 AS NVARCHAR(10)) AS 现金,
CAST(f.Segment8 AS NVARCHAR(10)) + '-' + CAST(f.Segment18 AS NVARCHAR(10)) + '-' + CAST(f.Segment28 AS NVARCHAR(10)) AS 项目,
CAST(f.Segment9 AS NVARCHAR(10)) + '-' + CAST(f.Segment19 AS NVARCHAR(10)) + '-' + CAST(f.Segment29 AS NVARCHAR(10)) AS 股东,
CAST(f.Segment10 AS NVARCHAR(10)) + '-' + CAST(f.Segment20 AS NVARCHAR(10)) + '-' + CAST(f.Segment30 AS NVARCHAR(10)) AS 杂项

      以上方法确保了字段拼接的一致性和可读性。