如何在上述程序段中加入'CLOSED'，'UNRESOLVED' [英] How do I incorporate 'CLOSED', 'UNRESOLVED' in the above program segment

问题描述

除了'打开'之外还需要介绍以下内容



'已关闭'



无人值守







IF @CINCIDENT<>'ALL'

BEGIN

IF @CINCIDENT ='OPENED'

SET @sql = @sql +'AND A.COMP_DATE + P.PROD_SERV_TAT> = GETDATE（）'

ELSE

SET @sql = @sql +'AND A.COMP_DATE + P.PROD_SERV_TAT< GETDATE（）'

结束









如何在上述程序段中加入'CLOSED'，'UNRESOLVED'





谢谢



我的尝试：



这是一项持续的发展

Need to introduce the following in addition to the 'OPENED'

'CLOSED'

'UNRESOLVED'



IF @CINCIDENT <>'ALL'
BEGIN
IF @CINCIDENT = 'OPENED'
SET @sql = @sql + ' AND A.COMP_DATE+P.PROD_SERV_TAT >= GETDATE()'
ELSE
SET @sql = @sql + ' AND A.COMP_DATE+P.PROD_SERV_TAT < GETDATE()'
END




How do I incorporate 'CLOSED', 'UNRESOLVED' in the above program segment


Thanks

What I have tried:

This is an on-going developement

推荐答案

这取决于你对合并的确切含义，但你可能想要检查ELSE IF中的CLOSED / UNRESOLVED：

It depends what exactly you mean with "incorporate", but you'll probably want to check for CLOSED/UNRESOLVED in the ELSE IF:

ELSE IF @CINCIDENT = 'CLOSED' 

< br $>
和

and

ELSE IF @CINCIDENT = 'UNRESOLVED' 

这篇关于如何在上述程序段中加入'CLOSED'，'UNRESOLVED'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！