Skipping Items in a Foreach Loop
Recently, my friend Jack Corbett asked a question on Twitter:
In a nutshell, the SSIS foreach loop will enumerate a given...
2009-09-16
5,775 reads
Blog Posts
Trust Is Crucial in Security
Yesterday we were greeted to a ComputerWorld column talking about how Apple had betrayed the Enterprise's trust by having a...
2009-09-16
735 reads
What's Your Build
This would probably be a good editorial, but I thought I'd drop it out here as a short note.
You ought...
2009-09-16
964 reads
Car Update – Electric plug in survey and algae hybrids
The Prius is having a few issues. I’ve had a slow leak in a tire that required two trips to...
2009-09-15
1,383 reads
First Meeting of the Charleston PASS Chapter
The first meeting of the Charleston PASS Chapter will take place Thursday night, September 17, starting at 6 PM. The first topic...
2009-09-15
737 reads
More Free Training
Quest Connect 2009, taking place in October 21 for 24 hours, looks like it’s going to have 64 different sessions, live...
2009-09-15
696 reads
Multiple Execution Paths
It’s not uncommon to find stored procedures that have multiple IF statements controlling the flow of execution within the procedure....
2009-09-15
756 reads
Networking Sins
I ran across this article about networking sins a while back and have had it on my list to share....
2009-09-15
1,364 reads
Networking While On Vacation
There's been a lot of attention given to professional networking (e.g. Andy Warren's blog posts) recently and if you recall...
2009-09-15
601 reads
No Join Predicate
You could be looking at an execution plan on a query and see this message: Warning, No Join Predicate. With...
2009-09-15
3,210 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
How Important Is a Google Knowledge Panel for Online Reputation?
I’ve been learning more about the google knowledge panel and it seems like one...
Which Wireless Credit Card Terminal Works Best for Small Businesses?
I’m currently researching the best wireless credit card terminal for a growing business and...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers