The Time Series algorithm has several parameters that may be adjusted if needed. I have tried adjusting several of these parameter settings and determined that the following appear to...
2013-12-04
17 reads
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time...
2013-10-22
944 reads
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time and enjoyed meeting new people. The following are a...
2013-10-22
12 reads
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time and enjoyed meeting new people. The following are a...
2013-10-22
4 reads
In SSRS, when you add a Series Group to a chart the data for each series is aggregated based on...
2013-08-31
11,188 reads
In SSRS, when you add a Series Group to a chart the data for each series is aggregated based on the series grouping specified. In some situations, you may...
2013-08-31
156 reads
In SSRS, when you add a Series Group to a chart the data for each series is aggregated based on the series grouping specified. In some situations, you may...
2013-08-31
5 reads
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child...
2013-08-13 (first published: 2013-08-07)
4,709 reads
I recently modified an SSRS report to display average run times for various SQL Agent jobs over the past 30,...
2013-08-09 (first published: 2013-08-05)
3,356 reads
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
38 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers