How to select recently updated row? I have problem in selecting a row in child sp which just got updated in parent SP. 

MySP updates MyTestTable's MonkeyColumn, and right after it want to return newly updated row to the user by calling to the GetMonkey procedure, but for some reason monkeyColumn is still empty. I know that i can use Output parameters, but then MySP will only return output parameters and not the result of GetMonkey stored procedure. What have i done wrong? 

Create PROCEDURE [dbo].[MySP]
    AS 
 Begin
      declare @testid uniqueidentifier
    select @testid = [dbo].GetTestIDFromParams(@someValue1)

        Update MyTestTable
         set MonkeyColumn = 'monkey',
             where id= @testid; 

        exec [dbo].GetMonkey @testid

  END


GetMonkey contains : 

Create PROCEDURE [dbo].[GetMonkey]
    -- Add the parameters for the stored procedure here
@testid uniqueidentifier
AS
Begin
SET NOCOUNT ON;
Select MonkeyColumn from MyTestTable where id= @testid;


END
The only scenario I can find that no results would be returned is if no row was updated. Architecturally speaking if that is actually your code and I would not bother making Stored Procedures that simplistic, just embed the SELECT query in the original Stored Procedure. Due to how SQL works if you start to get more complex with your queries trying to use certain Object Oriented habits by turning every duplicated or close to duplicated query into a Stored Procedure call can quickly become troublesome.