Monday, 9 January 2017

BizTalk BRE SQL Script: Get rule set details by policy name


declare @vRuleSetID int
declare @publish int = 0
declare @policyName varchar(200)
set @policyName = '%Policy_ProductDetails_v1%'

SELECT @vRuleSetID  = nRuleSetID FROM [dbo].[re_ruleset]
where strName like @policyName


SELECT * FROM [dbo].[re_ruleset] where nRuleSetID = @vRuleSetID
SELECT * FROM [dbo].[re_tracking_id] where nRuleSetID = @vRuleSetID

No comments:

Post a Comment