Creating a JSON Document II

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80411 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Bert De Haes Hall of Fame Points: 3386 More actions · Answer 2

The query

select json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;

generates an error. The alias n was forgotten. It should be

select json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams as n;