|
Home > Archive > MS SQL XML > July 2005 > contatenation of table column values into xquery expressions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
contatenation of table column values into xquery expressions
|
|
|
| How could I create XPath expressions from the table column values
below so that I can use them in an XPath query.
RuleID PropertyToTest op value score
1 property1 > 500000 10
2 property1 < 500000 5
3 propertyboolean1 = Yes 10
4 propertyboolean1 = No 5
I will be applying the expressions created from the values above against
objects which have been serialized into an XML document, eg;
CustomerID 1
property1 10000
propertyboolean1 Yes
CustomerID2
property1 600000
propertyboolean1 No
If the expressions applied against the objects in the XML doc are true, the
score will be added to an accumulated score for each Customer.
Thank you very much for any help. -hazz
| |
|
| its ok, I got over this idea...pleading temporary insanity for even trying
to go there. -hazz
"hazz" < greghazzard@nospamco
mcast.net> wrote in message
news:%23dzIetWgFHA.3316@TK2MSFTNGP14.phx.gbl...
> How could I create XPath expressions from the table column values
> below so that I can use them in an XPath query.
>
> RuleID PropertyToTest op value score
> 1 property1 > 500000 10
> 2 property1 < 500000 5
> 3 propertyboolean1 = Yes 10
> 4 propertyboolean1 = No 5
>
> I will be applying the expressions created from the values above against
> objects which have been serialized into an XML document, eg;
>
> CustomerID 1
> property1 10000
> propertyboolean1 Yes
> CustomerID2
> property1 600000
> propertyboolean1 No
>
> If the expressions applied against the objects in the XML doc are true,
> the
> score will be added to an accumulated score for each Customer.
>
> Thank you very much for any help. -hazz
>
>
>
|
|
|
|
|