How to build a rules table in sql server, Sql Server

Language: Layout:

Create table tblTest
(
    TranID int primary key not null,
    FName varchar(20) not null,
    Age int not null,
    Salary money not null,
    MaritalStatus char(1) not null
)

Insert into tblTest values (1, 'Alex', 26, '25000.00','Y')
Insert into tblTest values (2, 'Brenda', 25, '14500.00','Y')
Insert into tblTest values (3, 'Peter', 69, '50000.00','N')
Insert into tblTest values (4, 'Paul', 64, '74500.00','Y')

Create table tblBusRule
(
    RuleID int Primary key not null,
    ColName varchar(20) not null,
    Operator varchar(2) not null,
    ColValue varchar(10) not null,
    RuleOrder int not null
)

Insert into tblBusRule values (1, 'Age', '>=', '25', 1)
Insert into tblBusRule values (2, 'Age', '<', '65', 2)
Insert into tblBusRule values (3, 'Salary', '>', '15000.00', 3)

declare @sql nvarchar(max), @where nvarchar(max);
set @where = stuff((
  select '  and '+colname +' '+operator +' ' + colvalue+char(10)
    from tblBusRule
    order by RuleOrder
  for xml path (''), type).value('.','nvarchar(max)')
  ,1,6,'')

set @sql = 'select * ' +char(10)+'from tblTest'+char(10)+'where '+@where

select @sql as CodeGenerated
exec sp_executesql @sql

View schema
Execution time: 0,02 sec, rows selected: 5, rows affected: 7, absolute service time: 0,19 sec