Sql转意拼接

来源：互联网发布：联通和电信的网络制式编辑：程序博客网时间：2024/05/01 01:29

GetWorkPosName
select b.ID,((select OrganizationName from :EOPDBName..vw_All_Organization c where c.ID=b.OrgID)+'_'
+(case when b.GrpName is null then '' else b.GrpName+'_' end)
+(case when b.BudName is null then '' else b.BudName+'_' end)
+(case when b.UnitNo is null or b.UnitNo='' then '' else b.UnitNo+'_' end)
+(case when b.ResCode is null then '' else b.ResCode end)) as BudCode from RCR a inner join House b on a.ResID=b.ID where a.CstID=@CstID and b.OrgID=@OrgID

GetWorkPos
select ((select OrganizationName from :EOPDBName..vw_All_Organization c where c.ID=b.OrgID)+'_'
+(case when b.GrpName is null then '' else b.GrpName+'_' end)
+(case when b.BudName is null then '' else b.BudName+'_' end)
+(case when b.UnitNo is null or b.UnitNo='' then '' else b.UnitNo+'_' end)
+(case when b.ResCode is null then '' else b.ResCode end)) as BudCode from RCR a inner join House b on a.ResID=b.ID where b.ResCode=@ResCode and b.OrgID=@OrgID