We are looking for someone with skills in TSQL and XQuery to write a procedure that will find and display (in a table) a search string which can have different input options.
For demonstration purposes here’s a short example of the idea behind it:
Consider the following xml-doc:
<root>
<testA>
<stringA>A</stringA>
<option>1</option>
</testA>
<testB>
<stringB>B</stringB>
</testB>
</root>
An Example query could look like this: exec stringMatch”A+1,B”
this would match the above mentioned code, but stringMatch”A,B” is wrong because A+1 is different than just A.
The option-element can consist of -1 and 1 or it is not used at all, as in <testB>.
I’ve included a detailed readme.txt as well as a sample xml-file which shall get you started quickly.
Best regards,
Sven
