I have a table with the following format:
select sField, sCell, sValue from AnswerBank where fkUserOrder = 1697004
sField sCell sValue
-------- -------- --------
business_zip NA 19701
Business_Phone NA 302-222-2222
Business_City NA Bear
Corp_owner_info Corp_owner_info_State_1 CA
Corp_owner_info Corp_owner_info_Full_Name_1 Lance Burris
So I run a query for an order number and I get above list. Now I want to concatenate XML tags to my answers depending on the value of the sField and sCell.
For example is sFiels = 'business_zip' and sCell= NA then I should have:
However if sCell is not = NA I have to use the value from the sCell for my tag comparison
If sCell = 'Corp_owner_info_State_1' then my tag is:
I need help on doing this... I will open more questions to add more points if this is to complicated.