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