Everything is fine in the SP which seth has given

Only thing is i donot want to create #a like below

CREATE TABLE #a(

...

Hi Seth

i tried this but after exec of sql, when i try to do select * from $a, it throws error saying #a does not exists in database. The...

Hi Pradeep,

As it runs in widnwos authentication, if i create physical table and tehn try to drop it , issue with permisson will arise