I Want a Macbook
Video editing is a bit of a pain on a Windows PC I definitely have some flexibility with ULead’s Video...
2009-02-20
999 reads
Blog Posts
Want Information on Data Dude, Check Out DBProj.Com
If you use Data Dude (Visual Studio 2008 Team System Database Edition GDR), you might want to check out Gert...
2009-02-20
647 reads
You HAVE to Trust, you MUST Verify -and that may still not be enough!
In Brian Kelly's recent blog post, he makes an excellent case outlining why there are few options but to 'Trust' SQL...
2009-02-20
419 reads
You Must Trust Someone
After some recent talks with security folks and auditors, one of the things I have had a hard time getting across...
2009-02-20
3,096 reads
You Must Trust Your DBAs
This is a follow-on post to You Must Trust Someone. My point in that post was to establish that being...
2009-02-20
1,949 reads
Chain Blog from Tom LaRock
I have been tagged by Tom LaRock to write about “what was your first computer and what were some of...
2009-02-19
427 reads
CodeZone Rebranded to User Group Support Services
Announced in the past week or so, Microsoft has released an update to Codezone that expands the focus beyond just...
2009-02-19
727 reads
Denver SQL Server User Group Meeting - Tonight (20090219)!
Denver SQL Server User Group:
A “Biking Buddy” Adventure Works hospitality report. Always have something in common to talk about with...
2009-02-19
806 reads
New Years Resolutions 2009 – Feb Update
I haven’t reported on how my resolutions are going yet this year, but after speaking at the Boulder User’s Group...
2009-02-19
948 reads
Providing More Feedback on My New Book: Defining Extents
As some of you may know, I am writing a new book called High Performance Index Maintenance. As an experiment...
2009-02-19
810 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers