Detective Stories - Changing the Case
How to change your "UPPER" or "lower" case strings to a mixed case
Software Assurance Cuts Back
Software Assurance from Microsoft is losing a benefit and Steve Jones comments.
TSQL Challenge 41 - Extract email addresses from text data
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
When Times are Tough, Do You Rise to the Occasion?
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
Create a Performance Baseline Repository
This article demostrates how to create a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server.
Announcing the New PowerShell Virtual Chapter of PASS!
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
Risk Analysis
This Friday Steve Jones asks about your spending on Disaster Recovery and is it in line with the risks involved.
Sending multiple rows to the Database from an Application: Part I
New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.
Manage Database Projects With Visual Studio 2010
This article demonstrates how to manage database projects with Visual Studio 2010.
Data Distribution - Part 2
In the second part of this series, Leo Peysakhovich provides a mechanism for tracking real time data changes.
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Alamat kontak resmi BCA KCP Tidar
WhatsApp:0817866887 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
Alamat kontak resmi BCA KCU SOLO BARU
Tlp/Wa_Cs: 0817866887 Kawasan Terpadu The Park, Jl. Ir. Sukarno, Solo Baru, Madegondo, Kec. Grogol,...
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