Creating Your First SSAS 2012 Tabular Project
No matter how simple it is, new things come with some confusion; at least until you get used to it....
2012-02-21
4,574 reads
Samuel Vanga
Be careful with two digit years
I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have...
2012-02-14
762 reads
LAST_VALUE() Analytic Function–SQL Server 2012
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...
2012-02-07
2,704 reads
Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget
Charts present summary data in a visually appealing format. Following is a chart for sales over month:
Before
I frequently use a few...
2012-02-01 (first published: 2012-01-31)
7,981 reads
Read contents of a file to variable – SSIS
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...
2012-01-24
1,844 reads
#meme15 – Use. Twitter. Why?
Should an average Jane or Joe professional use twitter?
Yes.
Why?
Because, I’m using it.
Not enough reasons? <grumpy face> I knew you wouldn’t...
2012-01-16
675 reads
FIRST_VALUE() Analytic Function–SQL Server 2012
Given a customer table:
CREATE TABLE Customers
(CustId INT, OrderDate DATE, OrderAmount MONEY) ;
INSERT Customers VALUES
(1, ’2011-12-03', 12500)
, (1, ’2011-10-07', 15000)
, (1,...
2012-01-10
839 reads
Management Studio Split Tabs
This is by far the simplest and silliest post ever, but i just figured how to create vertical tabs in...
2012-01-05 (first published: 2012-01-03)
3,098 reads
Why doesn’t my gauge show correct values?
Here is an issue I encountered recently while using gauge in reporting services.
There are three gauges in the report one...
2011-12-27
1,018 reads
CONCAT() string function–SQL Server 2012
As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...
2011-12-22 (first published: 2011-12-19)
3,999 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