<![CDATA["求助,informatica该sql语句怎么实现" 主题的最后发表文章]]> http://www.mydwbi.com/posts/list/3.page JForum - http://www.jforum.net 求助,informatica该sql语句怎么实现 when a.EnterAccDate is null and a.ConfDate is not null then a.ConfDate
else a.MakeDate end)
这条sql语句怎么实现 谢谢各位]]> http://www.mydwbi.com/posts/preList/187/987.page http://www.mydwbi.com/posts/preList/187/987.page GMT 回复:求助,informatica该sql语句怎么实现 NOT [color=darkblue]ISNULL[/color](EnterAccDate), EnterAccDate,
[color=darkblue]ISNULL[/color](EnterAccDate) AND NOT [color=darkblue]ISNULL[/color](ConfDate), ConfDate,
MakeDate
)]]> http://www.mydwbi.com/posts/preList/187/988.page http://www.mydwbi.com/posts/preList/187/988.page GMT 求助,informatica该sql语句怎么实现 http://www.mydwbi.com/posts/preList/187/989.page http://www.mydwbi.com/posts/preList/187/989.page GMT 求助,informatica该sql语句怎么实现 when a.EnterAccDate is null and a.ConfDate is not null then a.ConfDate
else a.MakeDate end)
这条sql语句怎么实现 谢谢各位[/quote]

這個是sql server上的sql嗎？如果是oracle的話，應該可以直接用decode函數吧]]> http://www.mydwbi.com/posts/preList/187/993.page http://www.mydwbi.com/posts/preList/187/993.page GMT