Begin i end nisu potrebni, problem je ovde:
VALUES
(@patPersonID , EXEC create_log @patLogID )
Ne mozes raditi exec u okviru insert into
Rekao bih da bi ovo trebalo da radi:
Code:
CREATE PROCEDURE create_proba @patPersonID int, @patLogID int
AS
declare @return int
exec @return =dbo.create_log @patLogID
INSERT INTO [DentalDB].[dbo].[tblPatient]
(
[patPersonID],
[patLogID]
)
VALUES
(@patPersonID , @return)
Every hamster has his day.