• I'm afraid you wouldn't make it to the 2nd round. If you're interviewing for a job, you're not going to already have that table in there. Your query would return an error, and when you tell them that it's their fault for not having the table there already, your interview is over.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]