R Glen Cooper

  • Interests: SQL Server, VB.NET, mathematics

Navigating Trees With CTE

Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]

4.8 (5)

2021-04-19

4,541 reads

How To Avoid MERGE in SQL Server

Introduction This article shows how to script a basic merge between two tables, without using MERGE. This can be handy when you're merging a pair of tables with hundreds of columns, since the script doesn't know anything about them. This technique introduces and populates some auditing columns (IS_DELETED, IS_INSERTED, IS_UPDATED, TRANSACTION_DATE) for each record, and runs fast. […]

4 (3)

2020-04-14

9,540 reads

Blogs

Suggested Topics in Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

Abuse, Patience, and Understanding

By

I’ve been struggling with an author for a few months. I tried to work...

Daily Coping 21 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Vil du købe Xanor og Xanax piller her i Danmark uden recept

By solo

Der er ingen ekstra omkostninger. kontakt mig via e-mail ... frostvibe500@gmail.com Nogle fordele -...

Vil du købe Oxazepam 10 mg piller her i Danmark uden recept

By solo

Der er ingen ekstra omkostninger. kontakt mig via e-mail ... frostvibe500@gmail.com Nogle fordele -...

Vil du købe Equasym 10-30 mg piller her i Danmark uden recept

By solo

Der er ingen ekstra omkostninger. kontakt mig via e-mail ... frostvibe500@gmail.com Nogle fordele -...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers