SQL查询到SSIS列得出

发布于 2025-02-08 11:37:32 字数 393 浏览 1 评论 0原文

下午好，有人可以帮我这个SQL查询在SQL Server中的开发方式应该像派生列中的SSIS格式一样。

我当时想到一个substring的发现串，但我不太了解

SELECT  CASE    
        WHEN  RIGHT(SUBSTRING(DE_NOVEDAD,CHARINDEX('/Op. ',DE_NOVEDAD),12),7) like '64%'
        THEN REPLACE(REPLACE(REPLACE(RIGHT(SUBSTRING(DE_NOVEDAD,CHARINDEX('/Op.',DE_NOVEDAD),12),7),'/',''),'C',''),'.','') 
        ELSE 0
        END 
FROM NAME_TABLE

原文

Good afternoon, can someone help me how this sql query developed in SQL SERVER should look like in ssis format in a derived column, please.

I was thinking of a findstring with a substring, but I don't quite understand

SELECT  CASE    
        WHEN  RIGHT(SUBSTRING(DE_NOVEDAD,CHARINDEX('/Op. ',DE_NOVEDAD),12),7) like '64%'
        THEN REPLACE(REPLACE(REPLACE(RIGHT(SUBSTRING(DE_NOVEDAD,CHARINDEX('/Op.',DE_NOVEDAD),12),7),'/',''),'C',''),'.','') 
        ELSE 0
        END 
FROM NAME_TABLE

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

筑梦 2025-02-15 11:37:32

在SSIS上使用Findstring代替Charindex。

使用双引号而不是单引号。

使用IIF代替情况。

FINDSTRING(RIGHT(SUBSTRING([FullTimeString24], FINDSTRING([FullTimeString24] ,"/Op. ",1),12),7) ,"64%" ,1) > 0 ? REPLACE(REPLACE(REPLACE(RIGHT(SUBSTRING([FullTimeString24],FINDSTRING([FullTimeString24] ,"/Op. " ,1),12),7),"/",""),"C",""),".","") : "0"

Use FINDSTRING instead of charindex on ssis.

Use double quotation marks instead of single quotation marks.

Use IIF instead of CASE.

FINDSTRING(RIGHT(SUBSTRING([FullTimeString24], FINDSTRING([FullTimeString24] ,"/Op. ",1),12),7) ,"64%" ,1) > 0 ? REPLACE(REPLACE(REPLACE(RIGHT(SUBSTRING([FullTimeString24],FINDSTRING([FullTimeString24] ,"/Op. " ,1),12),7),"/",""),"C",""),".","") : "0"

回复收藏 0 原文

~没有更多了~