X++ SQL 代码转换为 SQL Server 代码:查找财务标签 RecId
SELECT TOP 1 dimAttributeFinancialTag.RecId FROM dimAttributeFinancialTag JOIN dimensionAttributeDirCategory ON dimAttributeFinancialTag.Category = dimensionAttributeDirCategory.DirCategory JOIN dimensionAttribute ON dimensionAttributeDirCategory.DimensionAttribute = dimensionAttribute.RecId WHERE dimAttributeFinancialTag.Value = '_value' AND dimensionAttribute.Name = '_dimensionAttrName';
原文地址: https://www.cveoy.top/t/topic/Nid 著作权归作者所有。请勿转载和采集!