Is there an equivelant to oracle's match_recognize in SQL Server? I believe this type of pattern matching was to become part of the SQL standard.
First, this is a forum for SSAS - Data Mining, not for database engine / Transact-SQL.
In SQL Server there is not equivalent for Oracle match_recognize available. If you need a function like "regular expressions" the you have to use a CLR implementation; see e.g.
Regular Expressions Make Pattern Matching And Data Extraction Easier
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?