Cloudy Days Ahead
Microsoft is investing heavily in cloud computing with several online services available
under the Azure Platform.
SQL Azure
The SQL Azure cloud...
2010-11-13
408 reads
pturley
PASS 2010 Summit Announcements and New SQL Server Developments
To say that this was a very full conference would be an understatement. The
SQL Server platform has grown to be...
2010-11-13
482 reads
Join us at PASS 2010!
Please join as at the 2010 global summit for the Professional Association for SQL
Server in Seattle. The conference is the...
2010-10-13
487 reads
Product Review: SnagIt 10
Screen captures have become part of our computer culture… “I’ll send you a screen
shot of the window so you can...
2010-09-02
500 reads
Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using
a dataset filter rather than the WHERE clause...
2010-08-30
618 reads
Project Phoenix: a Chance to Support the Community and Build a Career
Do you know someone with an IT background who could use a break, is passionate about
technology and wants to make...
2010-08-04
498 reads
2010 Microsoft BI Conference: Directions in Microsoft BI
The combined Microsoft BI Conference and TechEd in New Orleans last week was a great
experience. The shear magnitude of the...
2010-06-21
1,160 reads
BI Conference Grocery Shopping Demo
Help enter demonstration data for the Microsoft BI Conference.
Go to the shopping
demo web form and enter some transactions.
No...
2010-05-27
1,441 reads
Portland SQL Saturday / Code Camp 2010
Today was the Portland SQL Saturday and Code Camp at the University of Portland and
it was a great experience. I...
2010-05-23
424 reads
Presenting at 2010 European PASS – Sort Of
I was so looking forward to the trip to Germany to speak at the European PASS Summit
on April 22nd. Two...
2010-04-23
422 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