One the things I’ve been doing over the last year is sending out a monthly reminder email of upcoming events. Not revolutionary, I know. I’m sharing what we do...
2020-01-30 (first published: 2020-01-22)
160 reads
Code Camp will be March 28th, 2020 at Seminole State College. The fifteenth consecutive year! They are definitely interested in developer/end user SQL content and would like at least...
2020-01-07
40 reads
I want to wrap up the notes on SQLSaturday by writing about my approach to managing events that I’ve evolved at SQLSaturday but definitely applies to most events and...
2020-01-03 (first published: 2019-12-16)
261 reads
Feb 29, 2020 is the date for SQLSaturday Tampa, number 951. The call for speakers is open through January 10th, so you don’t have much time to get something...
2019-12-27
56 reads
One of the choices you make as an organizer is whether to buy anything that you want use or give away at the end of the event. Owning nothing...
2019-12-20 (first published: 2019-12-02)
179 reads
One of the things we’ve done most years in Orlando is to print poster sized schedules. This started out as a supplement to giving everyone a printed schedule and...
2019-12-09
15 reads
We just had our final event of the year and looking back, not bad at all. No event in June or November, but 18 overall (16 listed below, plus...
2019-12-05
27 reads
For the past few years we’ve had a a local sponsor provide cupcakes as the “sweet treat”. We started with mid afternoon but found it worked well if we...
2019-11-25
19 reads
We hold our event at a local college. The way it works is our contact tries to reserve ALL of the rooms in the building because we will end...
2019-11-18
11 reads
I like to say that the goal for any event is to meet the expectations of attendees. The trick is to set the expectations because if you don’t, they...
2019-11-11
29 reads
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Comments posted to this topic are about the item Fun with JSON II
Comments posted to this topic are about the item Changing Data Types
Comments posted to this topic are about the item Answering Questions On Dropped Columns
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