Error converting data type nvarchar to int

I am new to sql.This is my procedure.

ALTER PROCEDURE dbo.spValidateUserSecurityToken
AS
BEGIN
DECLARE @sdbname VARCHAR(10)
DECLARE @sownername VARCHAR(10)
DECLARE @servername VARCHAR(10)
DECLARE @procname VARCHAR(300)

SELECT
@servername = servername,
@sdbname = dbname,
@sownername = ownername

FROM
dbo.TestingProc

declare @Permission int
declare @nResult int
EXEC(@servername+'.'+@sdbname +'.'+@sownername+ '.'+'spCheckAWSiProcedurePermissionTest @nResult='+@Permission+' OUTPUT')
PRINT @Permission



i am getting the following error

Error converting data type nvarchar to int.


Please someone help me to find.

I guess, the string concatenation you are making with Int datatype, while firing EXEC is causing problem.
Try typecasting the Int variables to string while concatenating inside the EXEC statement.

Try this:

ALTER PROCEDURE dbo.spValidateUserSecurityToken
AS
BEGIN
DECLARE @sdbname VARCHAR(10)
DECLARE @sownername VARCHAR(10)
DECLARE @servername VARCHAR(10)
DECLARE @procname VARCHAR(300)
DECLARE @Permission INT
DECLARE @nResult INT

SELECT
@servername = servername,
@sdbname = dbname,
@sownername = ownername
FROM
dbo.TestingProc

SET @procname=@servername+'.'+@sdbname+'.'+@sownername+'.spCheckAWSiProcedurePermissionTest'
SET @Permission=0 -- OR whatever value you want to initialise with.

EXEC @procname @nResult=@Permission OUTPUT

PRINT @Permission
END

Thanks,

Bijesh

Thanks bijesh,it is working.