Meagan Longoria

Meagan Longoria is a consultant with Denny Cherry & Associates in Denver, CO where she shares her expertise in Microsoft BI and data warehousing through solution envisioning, architecture design, solution development, training, and blogging. She is a speaker at user groups and conferences across the country.

All authors

All authors

Blogs

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

FIRST_VALUE vs. Min: #SQLNewBlogger

By

I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...

Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join

By

This post comes off the back of my last, where I looked at issues...

Read the latest Blogs

Forums

Wahrung der Integrität der Prüfungsumgebung

By sergioblog066

Störsender für Prüfungssignale im Konferenzraum: Wahrung der Integrität der Prüfungsumgebung In der heutigen Zeit...

Subqueries II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Subqueries II

Distributed Monoliths

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distributed Monoliths

Visit the forum

Question of the Day

Subqueries II

What is wrong (if anything) with this code? 

SELECT *
 FROM Sales.SalesOrderHeader AS soh 
 WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)

See possible answers