存储过程最后返回的结果集如何跟函数返回的变量表连接
declare @sql varchar(500)
set @sql= 'select a.*,b.VTitle from VideoComment a inner join VideoInfo b on a.VID=b.VID where ' + @TimeFilter + 'and '+@VIDFilter
exec(@sql)--最后返回的结果集
dbo.Fun_GetChannelListByParID(ChannelID)--这个函数返回一个变量表
如何把这两个结果集连接起来
先谢过了
[解决办法]
declare @sql varchar(500)
set @sql= 'select * from dbo.Fun_GetChannelListByParID(ChannelID) union all '
set @sql= @sql + 'select a.*,b.VTitle from VideoComment a inner join VideoInfo b on a.VID=b.VID where ' + @TimeFilter + 'and '+@VIDFilter
exec(@sql)
[解决办法]
1.把存储过程的结果存成临时表#
2.连接
select * from dbo.Fun_GetChannelListByParID(ChannelID) a Inner Join # b on a.nid=b.ChannelID
