Brent get's asked this question a lot, so here he has set up an example with the Stack Overflow database. His query’s goal is to find the top 5 Locations, and list the users who live in those top 5 Locations, alphabetized by their DisplayName.
2019-06-21
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
2019-06-04
2018-12-20
974 reads
The post The pros and cons of self-service BI: What every industry leader should...
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
South Kerala tour packages offer an immersive experience into the heart of Kerala's natural...
Ever seen a corgi chihuahua mix black, or "Chigi"? This rare color variation makes...
I am running SQL Server 20.2. When I copy a query into the query...
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers