Now the above proc is working fine, the prob is i want to call that proc in a selec statement
select ID,(exec Proc ID) as Name from Table
I dont know how to do this but i want like this ...
You can't call a procedure as part of a select statement.
How does it return name? It can't be as a return value, that has to be int.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass