Query Hierarchical data Using CTE in T-SQL 2005

In response to Sam Stange's "An old and new way to query Hierarchical data", this script uses the new CTE feature of SQL Server 2005 to display the hierarchical data all at once. I have added a check to prevent infinite loop in case there is a loop in the data (actually, there is one […]

3.67 (3)

2007-04-11 (first published: )

1,375 reads

Function Based Index in T-SQL

To build function based index in SQL Server, you can use indexed view (materialized view) or using a computed column. In this script, I give an exmaple of how to use the computed column to implement a function based index on a table to search through a free formated telephone number column. The basic step […]

5 (3)

2007-04-10 (first published: )

5,265 reads

Blogs

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Upgrade 2014 Web Edition to Standard

By @SQLNumpty

Hello. I'm working with a client who currently has a SQL 2014 Web Instance...

Package failing but the table is already there and the system says its missing!!

By hurricaneDBA

Dear Everyone Im using SSIS 2019 and VS 2019 The data scientist gave me...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers