Some useful SQL for handling hiearchical/recursive queries

16 Kicks

submitted by fatdaveh(1420) 5 years, 8 months ago

I used several dodgy ways of handling hierarchical structures in my apps before coming across this handy snippet.

1 comment |category: ADO.NET |Views: 4
Tweet

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

Comments:

posted by dabbas(0) 5 years, 8 months ago 0

this should be done using a CTE in SQL Server 2005.

What's this?