RunAs
When I started working at JD Edwards, I was a corporate administrator
on the windows network. Since the DBAs were a...
2005-07-12
1,531 reads
Blog Posts
It's always something
As Phill posts in his blog, we've had a couple interesting threads in the forums where the respect and tolerance...
2005-07-11
1,440 reads
This is lovely
I got a note that someone thought they shouldn't have to register on
the site and get a newsletter to read...
2005-07-07
1,381 reads
What Is Really Interesting?
When I wrote the editorial for today on A Humbling Experience,
I was sure that it would generate a bunch of...
2005-07-07
1,498 reads
Interviewing a DBA
Andy and I had an interesting question on this today. He's trying to
hire a DBA and he had his first...
2005-07-05
1,581 reads
To Blog or Not To Blog
Blogging seemed like a big deal in 2004. At the 2003 PASS Summit, we were told by Microsoft that they...
2005-06-29
1,515 reads
My First Blog!
At least here 🙂 Normally I blog over at http://www.dkranch.net/
That's usually personal stuff going on in my life, so I'll try...
2005-06-28
1,409 reads
2001-01-01
14 reads
Courtney Woolum
A longer bio or profile text can go here in Markdown. There should be a lot more here
2001-01-01
1 reads
Privacy Policy
The Agile SQL CLub Privacy Policy (google Made me do it) The website uses cookies to track views and where you go, if you block cookies then they will...
2001-01-01
10 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I...
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Question of the Day
Fun with JSON II
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers