IS IT POSSIBLE TO EXEC SP INSIDE SP AND EXECCUTE IF BY THE R

Question

CONTEXT :

I WANT TO UPDATE THE FIELD OF TABLE 'A' TO FALSE

AND I WANT TO EXCECUTE ANOTHER STORED PROCEDURE AND BASED ON ITS RETURNED VALUE

I WANT TO CHECK THE IF CONDITION AND EXECUTE ANOTHER STATEMENT

IS IT POSSIBLE IF IT POSSIBLE HOW

MY SAMPLE CODE :

UPDATE CheckInOut SET IsActive=0,ActionStatus='D'

where VocherType=@VocherType

AND InOutMasterID=@InOutMasterID

AND BranchID=@BranchID

BEGIN

DECLARE COUNT1 AS INT

SELECT COUNT1=EXEC Check_ConfHallStatus @RoomID,@VocherType,@BranchID

IF(COUNT1>0)

BEGIN

UPDATE Rooms SET RoomStatus='Occupied' WHERE RoomID=@RoomID

END

ELSE

BEGIN

UPDATE Rooms SET RoomStatus='Vacant' WHERE RoomID=@RoomID

END

END

----------------------------------------

Check_ConfHallStatus :

ALTER PROCEDURE Check_ConfHallStatus

(

@RoomID BIGINT

--,@ActionStatus VARCHAR(5)

,@VocherType VARCHAR(15)

,@BranchID bigint

)

as

SELECT COUNT(*) AS CNT FROM CheckInOut

WHERE IsActive=1

AND RoomID=@RoomID

AND ActionStatus='A'--@ActionStatus

AND VocherType=@VocherType

AND BranchID=@BranchID

------------------------------------------------