It is basic knowledge that the ORDER BY clause will pretty much sort our data using available columns in a SQL Server table in ascending or descending order. But what if we want to allow a user of an application to resort items (rows) in a table in their own desired order where ascending or descending on existing columns would not work? For example, we might want to present a list of items and allow them to re-sort the items in any order they desire. How do we store and retrieve that data in a SQL Server table so that it displays in the order expected? This article will provide one … [Read more...]
How to Allow Users to Control Sort Order in SQL Server Results
September 28, 2017 by Leave a Comment
Don will be Freezin for a Reason!
February 16, 2016 by Leave a Comment
Brrr...I am jumping into the icy waters of Lake Lanier Saturday, February 20th. No, I’m not crazy - I’m raising money for the Special Olympics of Georgia and I need your help! Each year the Johns Creek Police Department (JCPD) participates with groups all over the US in the Polar Plunge which is the largest fundraising effort for the Special Olympics. It is presented by the Law Enforcement Torch Run of Georgia. Since I volunteer with JCPD in the Citizen Auxiliary Police Services (CAPS), I am participating in the 2016 Polar Plunge to raise money for the Special Olympics. This will be the … [Read more...]
