存储过程中执行存储过程，并把结果赋值给output参数

ALTER PROCEDURE [dbo].[xl_StockWarningQuery]
    @nCargoID bigint,
    @sCargoName varchar,
    @nCargoSup int,
    @nCargoBrand int,
    @sAdminName varchar,
    @pagesize int,
    @pageindex int,
    @count int output
AS
BEGIN
    
    declare @sql nvarchar(4000)
    declare @sql1 nvarchar(4000)

    set @sql = 'select * from
                (select
                ROW_NUMBER() OVER (order by a.sName asc) rownumber,
                a.nID as nCargoID,
                a.sName as sCargoName,
                c.sCompany as sSupName,
                e.sName as sCargoSize,
                f.sName as sCargoColor,
                g.sBrandName as nCargoBrand,
                b.nAmount as nCargoAmount,
                b.nVAmount as nCargoVAmount <