解开未完成的事务Kill命令，用变量接收另一个存储过程反回的值,将EXEC 存储过程的返回数据放到 SELECT 中 再过滤查询

use dycw2;
CREATE TABLE #TempBillList (  
    iOrderID int,
    cBillCode nvarchar(256),
    dBillDate nvarchar(256),
    cUnReason nvarchar(1024) default(''),
    bCanUpLoad int default(1),
);  
INSERT INTO #TempBillList EXEC pWDT_GetBillList_CGRK '', '';  
SELECT * FROM #TempBillList order by dBillDate desc,iOrderID desc
DROP TABLE #TempBillList;

exec pWDT_GetBillInfo_CGRK 'PF24040004'
select * from tUpload_StockBillInfo

declare @iEquipmentID int, @ISort int, @cType varchar(32), @cBillCode nvarchar(32), @cOperator varchar(12)
    
    select @iEquipmentID = IDENT_CURRENT('tEqaEquiDetail');
    select @cOperator=cOperator from tEqaEquiDetail where iEquipmentID = @iEquipmentID
    set @ISort = 1
    set @cType = '新增'
    
    create table #temp
    (
        cValue varchar(1024) null
    )
    set @sql = 'insert into #temp(cValue) exec dbo.pSysGetCode '''','''',-1,-1,''cBillCode_change_eqa'''
    exec (@sql);
    select @cBillCode = cValue from #temp
    drop table #temp;
    
    if @@error != 0
    begin
        goto problem
    end
    
    insert into tEqaChange (iEquipmentID, ISort, cType, cBillCode, dBill, dCreate, cOperator)values
    (@iEquipmentID, @ISort, @cType, @cBillCode, GETDATE(), GETDATE(), @cOperator)

select *  from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id = (select DB_ID())
DBCC OPENTRAN; 反回结果
kill 360