One of our internal people was looking to test some process in (I assume) Redgate Monitor and needed more job history than they had in msdb.sysjobhistory. They wanted to...
2024-12-09 (first published: 2024-11-27)
113 reads
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-12-09 (first published: 2024-11-27)
109 reads
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through your issues like a forest fire, which clears out your dry and hollow grievances and...
2024-12-06
16 reads
I had been meaning to post this, so as I finished a piece that referenced this, I decided to post the picture. This was from Small Data SF, where...
2024-12-06
16 reads
The 11th episode is now live, recorded a few weeks ago at the PASS Data Community Summit. This was a lot of fun, us grabbing a space in the...
2024-12-06 (first published: 2024-11-22)
148 reads
Announced at Microsoft Ignite last week were some new product features related to the data platform and AI. Check out the Major announcements and Book of News. Below are...
2024-12-06 (first published: 2024-11-26)
265 reads
The post Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch appeared first on Joyful Craftsmen.
2024-12-05
11 reads
This post comes off the back of my last, where I looked at issues caused by explicitly declaring a large number of values in an IN clause. The query...
2024-12-04
148 reads
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter asked about the difference between Min() and First_value. This post looks at a few cases....
2024-12-04
103 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful applications on Kubernetes.Even though almost no one questions using Kubernetes (K8s) to manage container applications...
2024-12-04 (first published: 2024-11-23)
346 reads
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Comments posted to this topic are about the item Getting ANY of the data
Comments posted to this topic are about the item Why Would You Do That?
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers