[导入]存储过程片段3

    declare @TempStr nvarchar(500)
 
    select @TempStr = InsIDs from Spe_UsedInstrument
                      where IReportNO = @IReportNO

    declare @sql varchar(2000)

    set @sql='select instrumentid , [name] , [sign] , model , area , grade
    from QA_ISTM_Instrument
    where instrumentid in ('''+replace(@TempStr,',',''',''')+''')'
    exec(@sql)
    print @sql

--InsIDs里面的数据的是用逗号隔开的

文章来源:http://blog.163.com/kwanchan@yeah/blog/static/8553861420086208122628