David Speight

In this example we want to list services followed by a service code.

Here is an example demonstrating how to SELECT between two separate SQL Instances. This assumes

This will alphabetize your list of items, split between two (2) columns.

Here is an example of using the LAG function in SQL 2012. A more detailed