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: You will never get back today, so make the most of it.
Recent Blog Entries
Add a JQuery Validate rule for No Date Greater Than Today
Published: Sep 22, 2020
Share this snippet from my archives for adding a JQuery Validate rule which disallows any date greater than today ...more
Populating a database column with an incrementing value
Published: Aug 25, 2020
Here's a quick way to populate a table column with an incrementing value in sql server. ...more
You can sort on columns by their column number
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
Delete duplicates but keep first record
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
Get the most recent entry for each group in sql server
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
Twitter Updates
- New blog entry: "Add a JQuery Validate rule for No Date Greater Than Today" https://t.co/sONxFpKoba #JQuery
- New blog entry: "Populating a database column with an incrementing value" https://t.co/cehGidIh1J #SQLServer
- New blog entry: "You can sort on columns by their column number" https://t.co/6ibmPzDu1N #SQLServer
- New blog entry: "Delete duplicates but keep first record" https://t.co/E6YeRbuNqu #SQLServer #SQL
- New blog entry: "Get the most recent entry for each group in sql server" https://t.co/Oua7QgRuTm #SQLServer
