Never mind, it will not be helpful unless those columns are not inter related. If you have columns which are not related, you need to execute separate query to get those values. That is what I meant.
[quote user="golden1237"]I did execute below scripts in one of the test environment with SQL 2000[/quote] Is this entire thread connected to SQL 2000? As you have posted it under SQL 2005 related forum many could have taken it as a SQL 2005 related question.