Sherry Li's BI Corner

Having worked with SSAS for a while and done some reporting with MDX queries, I started to explore opportunities to...

2012-10-16

1,561 reads

MDX #18 – Easy to concatenate row values into column in MDX

Concatenating row values (within groups) into column in SSRS and TSQL
Concatenating row values into column is a never ending topic...

2012-10-07

2,770 reads

Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...

No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...

A few years ago I took a new job at Microsoft, working as a...

Comments posted to this topic are about the item Let's Talk Certifications, which is...

Title pretty much says it. I want to join to a table that has...

Comments posted to this topic are about the item Building a SQL Server Fleet...

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', 'i')
 AND BusinessEntityID IN (7,8)