select * from
UBf_Print_Templates_UserCases as A where CatalogType=‘U9.SCM.SD.Ship’
–templateID=‘83a8009e-5f33-4850-9a0e-35d13c7db7a6’
–A.CatalogType='U9.SCM.PM.ReturnPrint’and
and
CreatedBy=‘黄晓珍’
select * from
UBf_Print_Templates where Culture=‘zh-CN’
and templateID=‘83a8009e-5f33-4850-9a0e-35d13c7db7a6’
delete
UBf_Print_Templates_UserCases where CatalogType=‘U9.SCM.SD.Ship’
–templateID=‘83a8009e-5f33-4850-9a0e-35d13c7db7a6’
–A.CatalogType='U9.SCM.PM.ReturnPrint’and
and
CreatedBy=‘黄晓珍’
SELECT t1.cName 报表名称,t2.cName 方案名称, t3.lUserID ,t3.lOrgID , t3.uReportCaseID
FROM dbo.UBF_MD_ASRPT_Category t1
LEFT JOIN dbo.UBF_MD_ASRPT_UserCase t2 ON t1.ID=t2.uReportID
LEFT JOIN dbo.UBF_MD_ASRPT_UserCaseInfo t3 ON t2.ID=t3.uReportCaseID
WHERE t1.cName LIKE ‘%明细账%’ AND t3.iUserCaseType = 6
根据以上信息删除默认方案:
DELETE t FROM dbo.UBF_MD_ASRPT_UserCaseInfo t WHERE uReportCaseID=‘36F8D4C1-A9D7-4150-8D0E-77449B855A31’ AND lOrgID=1001202263224223 AND lUserID =1001205240100022