Anyways, Thanks Toby

It is indeed a bad news but anyhow I have to get it done....... poor me :crying:

:ermm::(

Hi Toby

You are right again but i made a little modification in ur query and it started working in SQL 2000, I have added table alias as prefix for columns....

Hi SeanLange

You are right simply null can be inserted....

But its not a matter of 1 SP we have thousands of SPs to be migrated from SQl 2000 to SQl...

HI Toby White

Thanks for looking into it..............

You are right the above query is not working even in SQL 2000 but I missed an Order by clause in query to mention

If...