CTE

plural CTEs

1. abbreviationcountableinitialismuncountablemedicineInitialism of chronic traumatic encephalopathy.

   NFL players Ray Easterling, Junior Seau, Shane Dronett and Dave Duerson were found to have CTE after careers of repeated blows to the head. All died by suicide.

   2020 January 26, Leah Asmelash, “Why traumatic brain injuries can be dangerous”, in CNN

2. abbreviationcountableinitialismuncountablenatural sciencesInitialism of coefficient of thermal expansion.
3. abbreviationcountableinitialismcomputingInitialism of common table expression.

   A recursive CTE is where an initial CTE is built and then the results from that are called recursively in a UNION statement returning subsets of data until all the data is returned. This gives you the ability to create data in a hierarchical fashion, as you will see in the next example.

   2008, Robin Dewson, Beginning SQL Server 2008 Express for Developers, Apress, →ISBN, page 433

1. SingaporeabbreviationAbbreviation of Central Expressway.