SQL Server

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