Bill Cowan

Expand Template with Values from Result Set

This stored procedure extracts template variable names and values from a SQL result set in order to process the template.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2016-10-13 (first published: 2016-09-14)

372 reads

Next week I’m at VS Live in San Diego (register and join me) and...

Ten years ago today, I filmed a Pluralsight Play by Play on open source...

It’s time for T-SQL Tuesday again and this is a great prompt to start...

Comments posted to this topic are about the item Stored Procedures for Server-Level Object...

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

Comments posted to this topic are about the item The Costs of Multiple Platforms

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)