| http://www.w3.org/ns/prov#value | - and change to a cross apply /outer apply to do the same thing!Q, and then realized i wasn't making any headway on modifying an existing example to become an ITVF.before i reinvent the wheel, does anyone have one?here is an example of a scalar function, that is featuring a Tally Table to build the right string. run that on a million rows, and it bogs things down a wee bit.
|