How Far are You Willing To Go To Get Something?
There are important things in life and in our career, how far are you willing to go to get them?
2017-10-30
112 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
Don’t Underestimate the Importance of Good Co-workers
It is important to have people that do good work and are good to work with.
2017-10-17
96 reads
2017-09-05
311 reads
How do you go about team building?
Team building isn't easy, but important for people to work together well.
2017-07-11
66 reads
What do you do when you have a repetitive task to do?
When faced with repetitive tasks how do you go about doing them in a focused timely manner?
2017-05-11
151 reads
How do you come up with creative ideas?
It takes a creative mind to come up with new ideas. So how do you do it?
2017-04-21
110 reads
How do you define employee satisfaction?
This article explores aspects of a job that help one feel satisfied at work.
2017-04-10
98 reads
How do you go about making a big decision?
This article explores the author's way of making big decisions.
2017-04-04
72 reads
2017-01-05
83 reads
What do you do when you inherit a mess at work?
I have seen three common responses to database messes. My favorite is nuclear.
2016-12-06
264 reads
Blogs
Finding and Updating Duplicate IDs: #SQLNewBlogger
By Steve Jones
Finding duplicates was an interview question for me years ago, and I’ve never forgotten...
Optimising Costs: Strategies for Efficient Cloud Resource Management
By HeyMo0sh
Over time, I’ve realised that one of the hardest parts of cloud management isn’t...
Cost Visibility: Tracking and Analysing Your Cloud Spend
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
Forums
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
Answering Questions On Dropped Columns
Comments posted to this topic are about the item Answering Questions On Dropped Columns
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