|
-----------------------------------------------------------------Stored Procedure----------------------------------------------------------------------------------
CREATE PROCEDURE dbo.SelectRules
@screenID INT
AS
SELECT CD.ScreenID, CD.ResultText, R.CodeLHS, R.Operator, R.ValueRHS, R.Source,RGR.RuleGroupID, RGR.RuleJoinOperator, RGR.RuleSeqNum, RGGR.RuleGroupJoinOperator,
RGGR.RuleGroupSeqNum, R.RuleDescription
FROM CountryDetails AS CD INNER JOIN
RulesGroupGroupingRelations AS RGGR ON CD.RuleGroupGroupingID = RGGR.RuleGroupGroupingID INNER JOIN
RulesGroupRelations AS RGR ON RGGR.RuleGroupID = RGR.RuleGroupID INNER JOIN
Rules AS R ON R.RuleID = RGR.RuleID WHERE CD.ScreenID = @screenID
ORDER BY RGGR.RuleGroupGroupingID, RGGR.RuleGroupSeqNum, RGR.RuleGroupID, RGR.RuleSeqNum
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I am a .Net developer, currently working in Singapore worked wiith Societe Generale Global Solution Centre, Bangalore and was previously with Cognizant.I have more than 8 years of .Net experience in BFSI domain. I am an experienced developer in C#, VB.Net, Silverlight, WPF, WCF, LINQ, Entity Framework, SSIS, NHibernate, ASP.Net and SQL Server.