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...]
Archives for 2016
User Defined ReOrdering in a SQL Server Table
January 11, 2016 by Leave a Comment
Suppose you want to allow your users to re-order a set of rows in a SQL Server table. Once the user has defined the new order, you need to save that order in SQL Server so that you can re-display the rows in the new order. But how can you accomplish this? You probably added a new column to the target table appropriately named sort. But how do you update this sort column so that it can reflect the new order? Let's assume we have 3 rows as follows and we have ORDER BY sort in query so that they display as... IDNameSort 1Red1 2Blue2 3Red3 and then our user re-orders the … [Read more...]
