sql-tools/Import/阿新/SQLQuery6.sql

   
   DELETE TItem WHERE FId IN(SELECT FId FROM DeZhou_AXin..TItem WHERE FId > 0   )
   
EXEC PCopyTable 'TEmployee','DeZhou_AXin_XinChao..TEmployee',' AND FId > 0 '
 
EXEC PCopyTable 'TEmployeeSub','DeZhou_AXin_XinChao..TEmployeeSub',' AND FEmpId > 0 '

SELECT * FROM 

EXEC PCopyTable 'TItem','DeZhou_AXin..TItem',' AND FId > 0 '


SELECT * FROM sysobjects WHERE name LIKE 'TMember%' AND name NOT LIKE 'TMemberSale%'


UPDATE TItem SET FNo = FNo + '.003' WHERE FNo IN(SELECT FNo FROM DeZhou_AXin..TItem)
UPDATE DeZhou_AXin_XinChao..TCourse SET FNo = FNo + '.003' WHERE FNo IN(SELECT FNo FROM DeZhou_AXin..TCourse)
 
 UPDATE TCourse SET FNo = REPLACE(FNo,'.003','')
--<EFBFBD><EFBFBD><EFBFBD><EFBFBD>
UPDATE A
   SET A.FNo = A.FNo + '.002'
  FROM  DeZhou_AXin_XinChao..TBasicType AS A,TBasicType AS B
 WHERE A.FKey = B.FKey
   AND A.FNo = B.FNo

EXEC PCopyTable 'TBasicType','DeZhou_AXin_XinChao..TBasicType',' AND FKey = ''Department'' '
EXEC PCopyTable 'TBasicType','DeZhou_AXin_XinChao..TBasicType',' AND FKey = ''Position'' '
EXEC PCopyTable 'TBasicType','DeZhou_AXin_XinChao..TBasicType',' AND FKey = ''ItemType'' '
EXEC PCopyTable 'TBasicType','DeZhou_AXin_XinChao..TBasicType',' AND FKey = ''ItemDiscountType'' '
EXEC PCopyTable 'TBasicType','DeZhou_AXin_XinChao..TBasicType',' AND FKey = ''GoodsType'' '
EXEC PCopyTable 'TBasicType','DeZhou_AXin_XinChao..TBasicType',' AND FKey = ''GoodsUnit'' '


EXEC PCopyTable 'TBasicTypeSub','DeZhou_AXin_XinChao..TBasicTypeSub',' AND FBasicTypeId IN(SELECT FId FROM TBasicType) AND FBasicTypeId NOT IN(SELECT FBasicTypeId FROM TBasicTypeSub)'

EXEC PCopyTable 'TItem','DeZhou_AXin_XinChao..TItem',' AND FId != 0 '
EXEC PCopyTable 'TItemSub','DeZhou_AXin_XinChao..TItemSub',' AND FId != 0 '

EXEC PCopyTable 'TItemDiscountMaster','DeZhou_AXin_XinChao..TItemDiscountMaster',' AND FId != 0 '
EXEC PCopyTable 'TItemDiscountMid','DeZhou_AXin_XinChao..TItemDiscountMid',' AND FId != 0 '
EXEC PCopyTable 'TItemDiscountDetail','DeZhou_AXin_XinChao..TItemDiscountDetail',' AND FId != 0 '

EXEC PCopyTable 'TGoods','DeZhou_AXin_XinChao..TGoods',' AND FId != 0 '
EXEC PCopyTable 'TGoodsSub','DeZhou_AXin_XinChao..TGoodsSub',' AND FId != 0 '

DELETE TMemberCardTypeSub WHERE FCompId NOT IN(SELECT FId FROM TCompany WHERE FDeleted = 0 )

 EXEC PCopyTable 'TMemberCardType','DeZhou_AXin_XinChao..TMemberCardType',' AND FId != 0 '
 EXEC PCopyTable 'TMemberCardTypeSub','DeZhou_AXin_XinChao..TMemberCardTypeSub',' AND FId != 0 '
UPDATE DeZhou_AXin_XinChao..TMemberCardType SET FNo = FNo + '.003' WHERE FNo IN(SELECT FNo FROM DeZhou_AXin..TMemberCardType)

 EXEC PCopyTable 'TCourse','DeZhou_AXin_XinChao..TCourse',' AND FId != 0 '

 EXEC PCopyTable 'TMember','DeZhou_AXin_XinChao..TMember',' AND FMemId != 0 '
 EXEC PCopyTable 'TMemberCard','DeZhou_AXin_XinChao..TMemberCard',' AND FMemId != 0 '
 EXEC PCopyTable 'TMemberCourse','DeZhou_AXin_XinChao..TMemberCourse',' AND FMemId != 0 '
 EXEC PCopyTable 'TMemberCardAccount','DeZhou_AXin_XinChao..TMemberCardAccount',' AND FMemId != 0 '
 EXEC PCopyTable 'TMemberCardAcctHist','DeZhou_AXin_XinChao..TMemberCardAcctHist',' AND FMemId != 0 '
 EXEC PCopyTable 'TMemberCardOldAcctHist','DeZhou_AXin_XinChao..TMemberCardOldAcctHist',' AND FMemId != 0 '
 EXEC PCopyTable 'TMemberOldTransHist','DeZhou_AXin_XinChao..TMemberOldTransHist',' AND FMemId != 0 '
 EXEC PCopyTable 'TMemberPointHist','DeZhou_AXin_XinChao..TMemberPointHist',' AND FMemId != 0 '

 EXEC PCopyTable 'TMemberCourseLog','DeZhou_AXin_XinChao..TMemberCourseLog',' AND FMemId != 0 '


UPDATE DeZhou_AXin_XinChao..TMember SET FMemNo = 'A' + FMemNo 
WHERE FMemNo IN(SELECT FMemNo FROM DeZhou_AXin..TMember)

UPDATE DeZhou_AXin_XinChao..TMemberCard SET FCardNo = 'A' + FCardNo 
WHERE FCardNo IN(SELECT FCardNo FROM DeZhou_AXin..TMemberCard)



SELECT * FROM TMemberCardType 

UPDATE TMemberCardType SET FNo = FNo + '<EFBFBD><EFBFBD>ɾ',FDeleted = 1 
WHERE FId IN(SELECT FCardTypeId FROM TMemberCardTypeSub WHERE FCompId = dbo.FNCompID('002'))
AND FId NOT IN(SELECT FTypeId FROM TMemberCard)