Skip to content
Brian M McGarvie
  • About – Brian
  • About – Laura
  • Archives
  • Consultancy & Projects
  • Contact
  • The Scrabbler
  • Tools & Tips
    • Secure Password Generator
    • Web Development
      • Colour Chart
      • Url Decoder/Encoder
  • Travelling
  • WordPress
    • Plugins
  • SQL Server

    1. Home>
    2. SQL Server

    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…

    Continue ReadingDynamically sorting by a column in a Stored Procedure (SQL Server)

    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…

    Continue ReadingSQL – Select using current day…

    Tags

    Anagrams Android Board Games Caching Carribean Cayo Coco ColdFusion Concert CSS Cuba Development Approach File Parsing File Reading Firefox Food & Drink Golfer Havana HTC Desire Irish JavaScript Jokes jQuery music Panda Password Pause PHP Princess Cruises Programming Ranking review Robbie Williams Scrabble SEM SEO Sessions Session Security SQL SQL Server Text File Timer Title Tags Travel & Adventures Wait Web Design

    Pages

    • About – Brian
    • About – Laura
    • Archives
    • Consultancy & Projects
    • Contact
    • The Scrabbler
    • Tools & Tips
      • Secure Password Generator
      • Web Development
        • Colour Chart
        • Url Decoder/Encoder
    • Travelling
    • WordPress
      • Plugins

    View Brian McGarvie's LinkedIn profileView Brian McGarvie's profile

    I am open to doing some additional work & projects - depending on my time!

    View Laura McGarvie's LinkedIn profile View Laura McGarvie's profile

    Categories

    • All The Rest (4)
    • Comedy (1)
    • Diving (1)
    • Events (Concerts, Theatre etc) (9)
    • Food & Drink (2)
    • Fun & Games (1)
    • Genealogy (1)
    • General (5)
      • Humour (3)
        • Jokes (3)
    • HTC Desire (2)
      • Tips & Tricks (2)
    • Music (7)
    • Programming (19)
      • ColdFusion (3)
      • General (1)
      • JavaScript (2)
        • jQuery (2)
      • PHP (10)
      • SQL (2)
    • Review (7)
    • SEO & SEM (5)
    • Software (5)
      • Internet (3)
        • Browsers (3)
      • Mac (1)
    • Technology (5)
      • iPod (1)
      • Networking (2)
        • Security (2)
      • Video Production (1)
    • Travel & Adventures (7)
    • Web Design (7)
      • CSS (2)
    Copyright 2023