T-SQL

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

  • Script

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

2019-11-24

74 reads

ASCII Text Dump

  • Article

Introduction Recently, I had the task of analyzing a varchar field for special characters. The field contained text entered by the user with a standard US keyboard; however, the proprietary software was breaking up the text and delimiting it with characters whose ASCII values were above 127. Eyeballing the text that I dumped using a […]

4.75 (8)

2019-11-12

3,798 reads

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

  • Script

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

2019-11-12 (first published: )

477 reads

Blogs

T-SQL Tuesday #121: Gifts received for this year

By

At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

T-SQL Tuesday Gifts (#121)

By

It’s that time of month. I missed last month while traveling, but I wanted...

Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020

By

Are you a speaker in SQL Server topics? Come on out to Richmond, VA...

Read the latest Blogs

Forums

MM#https://wranglernationalfinalsrodeolive.co/stream/

By naginai

https://wranglernationalfinalsrodeolive.co https://wranglernationalfinalsrodeolive.co/live/ https://wranglernationalfinalsrodeolive.co/2019/ https://wranglernationalfinalsrodeolive.co/2019-live/ https://wranglernationalfinalsrodeolive.co/nfr-2019-live/ https://wranglernationalfinalsrodeolive.co/wrangler-2019-live/ https://wranglernationalfinalsrodeolive.co/tv-channel-coverage/ https://wranglernationalfinalsrodeolive.co/reddit/ https://wranglernationalfinalsrodeolive.co/stream/ https://wranglernationalfinalsrodeolive.co/wrangler-network-2019-live/ https://wranglernationalfinalsrodeolive.co/national-finals-rodeo-2019-live/ https://wranglernationalfinalsrodeolive.co/wrangler-nfr-2019-live/

MM#https://wrangleri.co/wrangler-network-2019-live/

By naginai

https://wrangleri.co https://wrangleri.co/live/ https://wrangleri.co/2019/ https://wrangleri.co/2019-live/ https://wrangleri.co/nfr-2019-live/ https://wrangleri.co/wrangler-2019-live/ https://wrangleri.co/tv-channel-coverage/ https://wrangleri.co/reddit/ https://wrangleri.co/stream/ https://wrangleri.co/wrangler-network-2019-live/ https://wrangleri.co/national-finals-rodeo-2019-live/ https://wrangleri.co/wrangler-national-finals-rodeo-2019-live/ https://wrangleri.co/wrangler-nfr-2019-live/

MM#https://wranglernationalfinalsrodeo-live.co/stream/

By naginai

https://wranglernationalfinalsrodeo-live.co https://wranglernationalfinalsrodeo-live.co/live/ https://wranglernationalfinalsrodeo-live.co/2019/ https://wranglernationalfinalsrodeo-live.co/2019-live/ https://wranglernationalfinalsrodeo-live.co/nfr-2019-live/ https://wranglernationalfinalsrodeo-live.co/wrangler-2019-live/ https://wranglernationalfinalsrodeo-live.co/tv-channel-coverage/ https://wranglernationalfinalsrodeo-live.co/reddit/ https://wranglernationalfinalsrodeo-live.co/stream/ https://wranglernationalfinalsrodeo-live.co/wrangler-network-2019-live/ https://wranglernationalfinalsrodeo-live.co/national-finals-rodeo-2019-live/ https://wranglernationalfinalsrodeo-live.co/wrangler-nfr-2019-live/

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers