hi dharmendr
see below was last SP:
select
(select Download.id from Download where Download.Authority=@Authority) id,
(select Download.url from Download where Download.Authority=@Authority) url,
(select Download.DownLoadToken from Download where Download.Authority=@Authority) DownLoadToken,
(select Temp_Users.pcode from Temp_Users where Temp_Users.Authority=@Authority) pcode
in last line I define that select pcode from temp_users how I can do it in your SP?
best regards
neda