SQL Street
I’m involved with with a new venture called sqlstreet.co.uk. SQL Street is the place to shop for database experts.
Here’s a...
2012-11-05
736 reads
I’m involved with with a new venture called sqlstreet.co.uk. SQL Street is the place to shop for database experts.
Here’s a...
2012-11-05
736 reads
Hundreds of expert level books, articles, videos and blogs has talked much about Transaction Logs and How well to manage it.
Everything from basics...
2012-11-05
1,917 reads
I assume at this point some of you are already in Seattle and even getting ready to attend Preconference Sessions....
2012-11-04
642 reads
Three days to go. I need to get my schedule sorted out, how about you. What influences your schedule? Since...
2012-11-03
555 reads
A reader asked me to share a C Sharp script I used in this post, SSIS #114 – How many ways...
2012-11-03
1,169 reads
The PASS Summit is coming up next week and that means that as the sun goes down, a number of...
2012-11-02
590 reads
Four days to the Summit. Will you be singing? Last year was my first time attending SQL Karaoke. While I...
2012-11-02
761 reads
Actually I’m not sure if anyone still believes this anymore. If you read the BOL description carefully it states that...
2012-11-02 (first published: 2012-10-31)
4,430 reads
Looks like I’m not the only one enjoying Friday.
Some of the staff at Red Gate had a Hawaiian day. Nice...
2012-11-02
1,043 reads
I’m continuing to work with the Surface.
BOOM
I just had my first crash. I was in IE when I tried to...
2012-11-02
1,160 reads
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Tlp/Wa_Cs:0817-866-887 Jl. Buah Batu No.192, Cijagra, Kec. Lengkong, Kota Bandung, Jawa Barat 40226
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
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