Hopefully you've heard about Reporting Services. But have you tried it? James says you'll be sorry if you don't read the docs first! Reporting is something every enterprise struggles with, maybe this will make things better? Here's how to get started.
2005-09-09 (first published: 2004-03-04)
36,330 reads
New Author! Written as a rant, this article covers a couple basic issues that STILL tend to get overlooked in a lot of places. It's run to rant sometimes but we plan to maintain our focus and continue to keep these a small percentage of our content. Let us know what you think.
2004-01-28
6,264 reads
By Steve Jones
Finding duplicates was an interview question for me years ago, and I’ve never forgotten...
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...
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