• ouch!! i'm one of the many who didnt read the end of the question (select 4) and answer based on sql 2005 functionalities 🙁

    Simon Liew
    Microsoft Certified Master: SQL Server 2008