Thanks for you quick response it is working 🙂

Anoop

here Crew is my database Error was

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near Crew

thanks Gauthama

🙂

Thanks vaseem

grate job!

Sorry i have tryed it is not working.

suppose I have a sp which returns boolean value 0 or 1 how can we get that value in another procedure in which we calling first sp.