Custom Navigation controls in SharePoint 2010
There are several ways to create a custom navigation control in SharePoint. In the below image you can see the...
2013-08-05
938 reads
Custom Coding in SQL Report Services
Reporting Services 2008 is a very powerful tool for creating reports. It contains many different tools and even allows you...
2013-07-29
720 reads
Creating a Rolling Date Range Named set in MDX
One Client I was working with wanted a named set that would give them the last 5 years. Of course...
2013-07-22
980 reads
SSAS Joining Facts at Different Granularities
In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example,...
2013-07-19 (first published: 2013-07-15)
2,129 reads
Report from a Cube in Reporting Services
Data warehousing has become a staple of businesses to help make business decisions. From these data warehouses you can develop...
2013-07-10 (first published: 2013-07-08)
2,680 reads
Create a Named Set with all but one Member in MDX – SSAS
I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all...
2013-07-05 (first published: 2013-07-01)
1,682 reads
Comparing Previous Rows in SQL
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular...
2013-06-24
750 reads
Pivoting weird data in SSIS – Sort of…
Sometimes we get data in some bad forms. For example look at the below table:
The names and the amounts are...
2013-06-18 (first published: 2013-06-17)
2,064 reads
SSRS – Using a Parameter to make Dynamic Columns
Multiple value parameters are a common tools used in SSRS. You can use this tool to select which columns actually...
2013-06-12 (first published: 2013-06-10)
3,693 reads
AS400 Program from SSIS
If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an...
2013-06-03
1,028 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