With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...
</pre><BR><BR>My method so far has been to select all clientIDs with multiple records (group by clientid having count(*) > 1) and using a cursor + dynamic SQL to insert all the records for a given ...