How to install Sql Server 2005 SP1 on existing SQL Server 2005 SP2 Ins

If you have existing install of Sql Server 2005 SP2 then it will not allow you to install Sql Server SP1 on it which is required for some applications especially Team Foundation Server install in Windows Server 2003. So here is a nice article telling how to workaround this situation.