The Business of Software
It's interesting being at a software company, especially one that's
building on another platform. I've never done this before, having
worked for...
2007-07-12
1,409 reads
It's interesting being at a software company, especially one that's
building on another platform. I've never done this before, having
worked for...
2007-07-12
1,409 reads
If you've spent much time at all reading Steve Jones's blog posts and SSC editorials, you quickly glean that he...
2007-07-12
1,486 reads
What: Midlands PASS Chapter July Meeting
Where: Training Concepts (250 Berryhill Road, Suite 502, Columbia, SC)
When: 6:15-8:00 PM
Speaker: SQL Server MVP...
2007-07-11
1,447 reads
Lots of debate and disagreement on my recommendation to wait for SQL
Server 2008 instead of upgrading to SQL Server 2005...
2007-07-11
1,444 reads
Just when I was about to start a pool for the release date, Microsoft announced today it will release on...
2007-07-10
1,395 reads
Despite my casual approach to the editorials and my job, this is still
something of a business and Red Gate wants...
2007-07-10
631 reads
I haven't posted much lately, but it has been a busy few months with many family activities. At work, I...
2007-07-09
442 reads
I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information...
2007-07-09
1,148 reads
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
911 reads
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
605 reads
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
WhatsApp:0817866887 Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
WhatsApp:0817866887 Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok, Jawa Barat 16423
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