SELECT
NEWID(),
d.displayValue,
t.displayValue,
w.displayValue,
main.displayValue,
REPLACE(main.celladdress, ' ', ''),
s.displayValue,
GETDATE(),
main.rep_top_id,
main.def_top_org,
main.sheetNo,
'103'
FROM [dbo].[T_12#] main
CROSS APPLY (
SELECT TOP 1 displayValue
FROM [dbo].[T_12#] d
WHERE REPLACE(SUBSTRING(d.CELLADDRESS,2,2),'$','') = REPLACE(SUBSTRING(main.celladdress,2,2),'$','')
AND d.type = 'Date'
AND REPLACE(RIGHT(RTRIM(d.CELLADDRESS), 2),'$','') = '2'
AND d.rep_top_id = main.rep_top_id
AND d.def_top_id = main.def_top_id
AND d.sheetNo = main.sheetNo
) d
CROSS APPLY (
SELECT TOP 1 displayValue
FROM [dbo].[T_12#] t
WHERE REPLACE(SUBSTRING(t.CELLADDRESS,2,2),'$','') = REPLACE(SUBSTRING(main.celladdress,2,2),'$','')
AND t.type = 'Time'
AND REPLACE(RIGHT(RTRIM(t.CELLADDRESS), 2),'$','') = '3'
AND t.rep_top_id = main.rep_top_id
AND t.def_top_id = main.def_top_id
AND t.sheetNo = main.sheetNo
) t
CROSS APPLY (
SELECT TOP 1 displayValue
FROM [dbo].[T_12#] s
WHERE REPLACE(SUBSTRING(s.CELLADDRESS,2,2),'$','') = REPLACE(SUBSTRING(main.celladdress,2,2),'$','')
AND s.type = 'KeyboardText'
AND REPLACE(RIGHT(RTRIM(s.CELLADDRESS), 2),'$','') = '5'
AND s.rep_top_id = main.rep_top_id
AND s.def_top_id = main.def_top_id
AND s.sheetNo = main.sheetNo
) s
CROSS APPLY (
SELECT TOP 1 displayValue
FROM [dbo].[T_12#] w
WHERE REPLACE(SUBSTRING(w.CELLADDRESS,2,2),'$','') = REPLACE(SUBSTRING(main.celladdress,2,2),'$','')
AND w.type = 'Select'
AND REPLACE(RIGHT(RTRIM(w.CELLADDRESS), 2),'$','') = '6'
AND w.rep_top_id = main.rep_top_id
AND w.def_top_id = main.def_top_id
AND w.sheetNo = main.sheetNo
) w
WHERE main.type IN ('InputNumeric', 'Calculate')
AND TRY_CAST(REPLACE(RIGHT(RTRIM(main.CELLADDRESS), 2), '$', '') AS INT) >= 7
AND main.def_top_org IN (SELECT T_DEF_TOP_ID FROM (SELECT DISTINCT [T_DEF_TOP_ID]
FROM [dbo].[T_LIMIT]
WHERE T_LINETYPE IN ('1#_GG','2#_GG','12#_GG') ) def )
AND main.displayValue IS NOT NULL; 这一段语句报错，消息 50000，级别 16，状态 30，过程 dbo.P_12#GG，行 158 [批起始行 2]
将截断字符串或二进制数据。
最新发布
扫一扫
972
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
