SQL Server – Brian M McGarvie

Dynamically sorting by a column in a Stored Procedure (SQL Server)

Post author:Brian M McGarvie
Post published:September 10, 2007
Post category:Programming SQL
Post comments:0 Comments

Have you ever needed to build a stored procedure that would take the name of a column as a parameter, and return the results ordered by that column? So have…

SQL – Select using current day…

Post author:Brian M McGarvie
Post published:August 23, 2007
Post category:Programming SQL
Post comments:0 Comments

I've had this problem a few times, and many people always ask me it... so here it is immortalised. If you require to select all records added to your table…