字段值连接成一个字符串

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

   
ALTER PROCEDURE [dbo].[CCC_IsUploadPhysicalDel]   
   
AS   
 BEGIN   
   
  --============ Author : Connie Chen   
  --============ Create Time : 2010-12-23 16:04:00.893   
  --============ Description : Get all fids from table ccc_tadetail. it prepare to upload into AS400.   
  DECLARE @DetailFIDs VARCHAR(2000)    
   
  SELECT    
   @DetailFIDs = COALESCE(@DetailFIDs + ',', '') + CAST(CCC_Del_TADetail.DeletionTablePrimaryID AS VARCHAR(10))    
  FROM    
 ( 
  SELECT TOP 100 * FROM CCC_DeletionSync   
  WHERE    
   DeletionTable = 1 AND IsUploaded is null   
 ) CCC_Del_TADetail 
 
  --============ Author : Connie Chen   
  --============ Create Time : 2010-12-23 16:04:00.893   
  --============ Description : Get all fids from table ccc_deliveryconfirminfo. it prepare to upload into AS400.   
  DECLARE @DeliveryConfirmIDs VARCHAR(2000)    
   
  SELECT    
   @DeliveryConfirmIDs = COALESCE(@DeliveryConfirmIDs + ',', '') + CAST(CCC_Del_DeliveryConfirm.DeletionTablePrimaryID AS VARCHAR(10))    
  FROM    
 ( 
  SELECT TOP 100 * FROM CCC_DeletionSync   
  WHERE    
   DeletionTable = 2 AND IsUploaded is null   
 ) CCC_Del_DeliveryConfirm 
   
  --============ Author : Connie Chen   
  --============ Create Time : 2010-12-28 16:04:00.893   
  --============ Description : Get all id from table CCC_DeletionSync   
  SELECT    
   LEN(@DetailFIDs) AS IDLens,@DetailFIDs AS IDs, DeletionTable , 'CCC_TADetail' AS DeletionTableName    
  FROM    
   CCC_DeletionSync   
  WHERE DeletionTable = 1 AND IsUploaded is null   
  GROUP BY DeletionTable   
   
    
  UNION    
  (     
   SELECT    
    LEN(@DeliveryConfirmIDs) AS IDLens,@DeliveryConfirmIDs as IDs, DeletionTable , 'CCC_DliveryConfrimIn' AS DeletionTableName   
   FROM    
    CCC_DeletionSync   
   WHERE DeletionTable = 2 AND IsUploaded is null   
   GROUP BY DeletionTable   
  )   
   
 END
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值