This site is a test bed for everything I learn and is mostly for my own benefit. As such it may be down from time to time and is subject to frequent changes.
Thought of the day: Work smarter, not harder.
Recent Blog Entries
Published: Sep 22, 2020
Share this snippet from my archives for adding a JQuery Validate rule which disallows any date greater than today ...more
Published: Aug 25, 2020
Here's a quick way to populate a table column with an incrementing value in sql server. ...more
Published: Aug 18, 2020
While not a great idea, it is possible (at least in SQL Server) to order on a column by its numeric column number in the query. ...more
Published: Aug 11, 2020
Expanding on last weeks article about finding the most recent entry in each group we can apply the same technique to delete duplicate database entries while keeping the first original entry. ...more
Published: Aug 4, 2020
To get the most recent entry for each named group within a sql server table table use partition and number rows by group as follows... ...more