Hi,

  Use Return statement in the stored proc instead of "select person_id"

 then

Declare @outvariable int

Exec @outvariable=getuser(<the required parameters&gt

select ourresult=@outvariable

I trust this clears u...

Hi,

 Use this

select

rank() over (order by

Hi,

  Use this 

select

column_name from information_schema.columns where table_name