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