Sql转意拼接
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