Blog of a Web Developer

Steven Neiland

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

Comments (0)


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

Comments (0)


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

Comments (1)


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

Comments (1)


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

Comments (0)

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