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...]
SQL Server – Age Calculations – Day vs Hour
November 15, 2015 by Leave a Comment
If you need to calculate age in days using SQL Server Transact-SQL, you have lots of options. When your age should be displayed in elapsed "days" for example, you might think that using the DAY attribute in DATEDIFF() would be the way to go. But you may want to use HOUR rather than DAY if your calculations must be accurate. Why? Because with DATEDIFF() using DAY, calculations are based on midnight boundaries. This means that your number of days will change if you are before or after the midnight boundary. For example, your actual time-span may have only been a couple of hours … [Read more...]
