This is not working for me, can you suggest what is the issue in below code:

DECLARE @myCount int;

DECLARE @sql1 nvarchar(MAX);

DECLARE @DBAT [varchar](10) = 'LS_EG_DEV'

DECLARE @sql nvarchar(max);

set @sql =

N'BEGIN

SELECT count(*) into :mCount FROM OWNER_CDG.CLI_CLIENT;

END;'

SET @sql1 = N'(@sql, @myCount OUTPUT) at ' + @DBAT

SELECT @sql1

SELECT @sql1 = 'EXEC ' + ( @sql1)

SELECT @sql1

EXEC (@sql1)