字段值连接成一个字符串

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

转载于:https://www.cnblogs.com/zhangchenliang/archive/2011/06/20/2085026.html

最新回复(0)
/jishuzNnb1TiVh0haVwK10b_2Fq1V9PLGilRRQDWSlwHc1GTC8_3D4795195
8 简首页