摘要:
-- --开始执行,递归查出该末级科目及所有上级科目 WITH TEMP AS ( SELECT fy_cost.CostGUID,fy_cost.ParentGUID FROM fy_cost WITH (NOLOCK) WHERE CostGUID IN ('dff10db2-de87-4b5a 阅读全文
摘要:
--开始更新 UPDATE a SET a.ProviderTypeNames=b.ProviderTypeNameList FROM fy_Provider a INNER JOIN [IP2].[数据库名].dbo.p_Provider b ON a.ProviderGUID=b.Provide 阅读全文
摘要:
--备份报销推送记录表 DECLARE @ctime NVARCHAR(36) = '2022-06-13 00:42:26' IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[p_Provider2B 阅读全文
摘要:
CASE WHEN fy_Contract.IsForeignCurrencyEnabled=1 THEN '是' ELSE '否' end IsForeignCurrencyEnabled,--as 是否外币CASE x_fy_Income.x_ApproveMode WHEN 1 THEN '线 阅读全文
摘要:
select A.*,B.x_UserGuid from ( select count(CreatedGUID) ss ,max(CreatedTime) maxdate,CreatedGUID from x_myUserExt group by CreatedGUID) Aleft join x_ 阅读全文
摘要:
SELECT STUFF((SELECT ','+x_SourceType FROM x_fy_ContractSource WHERE x_fy_ContractSource.x_ContractGUID='20f5a958-a79a-4d90-fe8d-08d948d27530' for xml 阅读全文