I'm trying to extend the Regex functionality that yoinky discussed in the following thread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27205
I'm trying to do multiple finds from a table of regex's. Essentially, I have a table of URL regex's. I have another table of URLs.
What I'm looking for is a list of URLs that match any of the regex's in the regex table. I can do this just fine with the non-obj functions you provided, but I can't figure out how to do this with the Obj functions.
Here's what I'm doing with this non Obj functions (which takes forever to execute):
Where dbo.regexFind(URLs.URL, RegExURLs.RegExURL, 1 ) = 1
Any help would be greatly appreciated!