感谢您提供的有用提示I''mu现在唱出更正，我会告诉你它是怎么回事。

thanks for the helpful tips I''m using the corrections now and i''ll let you know how it went.

我修改了查询，最后我得到了以下错误。还有另一种在T SQL中表示空白值的方法吗？


SELECT

[加载ID]，

[货件标识]，

[结束日期]，

[SH Arv D Loc日期]，

[结束TS]，

[SH Arv D Loc TS]，

[SH Arv D Loc TS] - [结束TS] AS [方差]，

[Conf Mode]，

[运输方式Grp]，

[CUDC标志] AS [CUDC]，

[XPD]，

[ FP标志] AS [LCFP]，

[CFAL]，

[CRTR]，

[MCAC]，

[MNMC]，

情况当[XPD] = 1或[CRTR] = 1那么1 ELSE 0结束为XPDFlag，

情况[CUDC标志] = 1那么0结束[CUDC]，

情况[FP标志] = 1然后0结束[LCFP]，

情况[CFAL] = 1那么' '晚''结束为[CFAL]，

情况[MCAC] = 1那么''晚''结束为[MCAC]，

情况下[SH Arv D Loc Date]> [End Date] THEN''Late''ELSE NULL END AS [LTL OT]，

CASE WHEN [MNMC] = 1 THEN NULL END AS [MNMC]，

[方差]时的情况> 0.010416667那么'晚''结束为[XPD OT]，

情况[方差]> 0.166666667然后''晚''结束为[TL OT]

- 当[XPD] = 1或[CRTR] = 1然后[XPD OT]结束时

INTO [temp_Ontime_test]

FROM [tblShipments]

WHERE [OT] =''晚''

和[运输工具Grp] =' 'TM2''


消息8133，等级16，状态1，行1

CASE规范中的结果表达式都不是NULL。

Msg 207，Level 16，State 1，Line 26

无效的列名''Variance''。

Msg 207，Level 16，状态1，第27行

无效的列名称''Variance''。

I modified the query and I''m getting the following errors at the end. Is there another way to represent a blank value in T SQL ?

SELECT
[Load Id],
[Shipment Id],
[End Date],
[SH Arv D Loc Date],
[End TS],
[SH Arv D Loc TS],
[SH Arv D Loc TS]-[End TS] AS [Variance],
[Conf Mode],
[Transport Means Grp],
[CUDC Flag] AS [CUDC],
[XPD],
[FP Flag] AS [LCFP],
[CFAL],
[CRTR],
[MCAC],
[MNMC],
CASE WHEN [XPD] = 1 OR [CRTR] = 1 THEN 1 ELSE 0 END as XPDFlag,
CASE WHEN [CUDC Flag] = 1 THEN 0 END AS [CUDC],
CASE WHEN [FP Flag] = 1 THEN 0 END AS [LCFP],
CASE WHEN [CFAL] = 1 THEN ''Late'' END AS [CFAL],
CASE WHEN [MCAC]=1 THEN ''Late'' END AS [MCAC],
CASE WHEN [SH Arv D Loc Date]>[End Date]THEN ''Late'' ELSE NULL END AS [LTL OT],
CASE WHEN [MNMC]= 1 THEN NULL END AS [MNMC],
CASE WHEN [Variance] > 0.010416667 THEN ''Late'' END AS [XPD OT],
CASE WHEN [Variance] > 0.166666667 THEN ''Late'' END AS [TL OT]
--CASE WHEN [XPD]= 1 Or [CRTR] = 1 THEN [XPD OT] END
INTO [temp_Ontime_test]
FROM [tblShipments]
WHERE [OT] = ''Late''
AND [Transport Means Grp] = ''TM2''


Msg 8133, Level 16, State 1, Line 1
None of the result expressions in a CASE specification can be NULL.
Msg 207, Level 16, State 1, Line 26
Invalid column name ''Variance''.
Msg 207, Level 16, State 1, Line 27
Invalid column name ''Variance''.