SET @re = N''
SELECT @re = @re
+ A.NoSplit + RIGHT(ISNULL(ISNULL(ISNULL(C.value, A.NoValue), B.NoValue), '<NULL>'), A.NoLen)
FROM No A
INNER JOIN(
SELECT NoName = '全宗号', NoValue = @全宗号 UNION ALL
SELECT NoName = '归档年度', NoValue = @归档年度 UNION ALL
SELECT NoName = '分类号', NoValue = @分类号 UNION ALL
SELECT NoName = '保管期限', NoValue = @保管期限 UNION ALL
SELECT NoName = '案卷号', NoValue = @案卷号 UNION ALL
SELECT NoName = '页号', NoValue = @页号
)B
ON A.NoName = B.NoName
LEFT JOIN(
SELECT ValueName = '<YEAR>', Value = CONVERT(varchar(10), CONVERT(char(4), @GETDATE, 120)) UNION ALL
SELECT ValueName = '<MONTH>', Value = RIGHT(CONVERT(char(6), @GETDATE, 120), 2) UNION ALL
SELECT ValueName = '<DAY>', Value = RIGHT(CONVERT(char(8), @GETDATE, 120), 2) UNION ALL
SELECT ValueName = '<永久>', Value = 'Y'
)C
ON ISNULL(A.NoValue, B.NoValue) = C.ValueName
WHERE A.SortID = @SortID
AND A.Diable = 0
ORDER BY A.OrderID
RETURN(STUFF(@re, 1, 1, ''))
END
GO