I won't even try to hide it. I got a huge kick out of the penguin characters in the animated movie, Madagascar. For those who don't know, they're trying to escape the zoo, but are trying to hide that from anyone discovering it. So, they put up a front, "Smile and wave boys. Smile and […]
2025-03-22
86 reads
I just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]
2025-02-15
128 reads
Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days […]
2025-01-11
70 reads
Yesterday morning I sat down to start a new project. Before I got started, I knew I needed to put this in source control. Now, the project was going to be in AWS, but, AWS has shut down their flavor of Git, CodeCommit. I decided to use GitHub instead, no big deal. Well, until I […]
2024-12-14
106 reads
Last week the 2024 PASS Data Community Summit conference was held in Seattle. 1,700 of my closest friends got together for a week of learning (well, technically it's a three day conference, but there are two days of pre-conference seminars) and sharing. I'm still exhausted a week later (although, old age and an aggressive travel […]
2024-11-16
118 reads
Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]
2024-10-19
277 reads
2024-09-21
139 reads
I'm a little excited because tomorrow I'm going to my first maker's faire. I'll be volunteering with our local radio club (100 year old, W5IAS, oldest radio club in Oklahoma). In addition, I'll be showing off a few controller chips & Raspberry Pis that I use with my radios for APRS, satellite tracking, and digital […]
2024-08-24
65 reads
2024-07-31 (first published: 2019-09-20)
633 reads
You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were […]
2024-07-27
144 reads
By HeyMo0sh
Over time, I’ve realised that one of the hardest parts of cloud management isn’t...
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
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