SQLTeam.com | Weblogs | Forums

Parse the business rules query to Tsql


I want to convert the following column "BusinessRules provided in Tableau calculated field" values to TSQL and the rules are nearly 1000 rules.
Here is the sample data.

BusinessRuleID BusinessRuleName BusinessRules provided in Tableau calculated field
1 Gender CASE[Q3 Gender Multiple Choice Question]WHEN '1.Male' THEN 1 ELSE 0 END AND CASE [Q6S Smoke Multiple Choice Question]WHEN '1. Yes' THEN 1 ELSE 0 END
2 Subects IF (ATTR([Market]) = Africa AND SUM([Sales]) > [Emerging Threshold] )THEN 1 Else 0

Thanks for your help in advance !!
indent preformatted text by 4 spaces