MDX Puzzle #6
As we continue with the puzzles, I will continue to introduce new MDX functions. In this puzzle the requirements are...
2010-08-25
626 reads
As we continue with the puzzles, I will continue to introduce new MDX functions. In this puzzle the requirements are...
2010-08-25
626 reads
After spending a week in Tampa, FL at a client site I've had some time to unwind and reflect back...
2010-08-23
958 reads
So, I was recently asked if you could display a vertical bar on a line graph to denote the last...
2010-08-11
3,326 reads
Again I want to apologize for the slow posting of the solution to this puzzle, but I have been hard...
2010-08-10
576 reads
In this three part series SQL Server MVP Andy Leonard will discuss SSIS Design Patterns.
Speaker: Andy Leonard
Add To Outlook:...
2010-08-08
1,071 reads
We are just about a week away from probably the biggest FREE training event to ever take place in Baton...
2010-08-06
553 reads
Do you have a challenging SQL Server or .Net issue that is causing you to have sleepless nights? Well, we...
2010-08-03
515 reads
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
547 reads
This puzzle may not have been much of a challenge, but it introduced two new MDX concepts. I have to...
2010-07-30
1,553 reads
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,010 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Telp/wa 085169998803 Jl. Suari No.18, Purwodinatan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50121
BCA KCP Radio Dalam Hub.0821•3111•185 Jl. Radio Dalam Raya No.5 B-C, Gandaria Utara, Kec....
BCA KCP Pasar Kebayoran Lama Hub.0821•3111•185 Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers