存储过程之间可以用union all吗?如果不能怎么实现啊?
这是三个存储过程查出来的,我想把他们并成一个表exec p_i_general_today '13974509','小雨卓'
今日分析 799 210 0 0 0.00%
exec p_i_general_yesterday '13974509','小雨卓'
昨日分析 1619 383 0 0 0.00%
exec p_i_general_sevenday'13974509','小雨卓'
前七天分析 7401 2044 0 0 0.00%像下面这样。今日分析 799 210 0 0 0.00%
昨日分析 1619 383 0 0 0.00%
前七天分析 7401 2044 0 0 0.00% 我这么写不对啊:
exec p_i_general_yesterday '13974509','小雨卓'
union all
exec p_i_general_yesterday '13974509','小雨卓'
union all
exec p_i_general_sevenday'13974509','小雨卓'
这是三个存储过程查出来的,我想把他们并成一个表exec p_i_general_today '13974509','小雨卓'
今日分析 799 210 0 0 0.00%
exec p_i_general_yesterday '13974509','小雨卓'
昨日分析 1619 383 0 0 0.00%
exec p_i_general_sevenday'13974509','小雨卓'
前七天分析 7401 2044 0 0 0.00%像下面这样。今日分析 799 210 0 0 0.00%
昨日分析 1619 383 0 0 0.00%
前七天分析 7401 2044 0 0 0.00% 我这么写不对啊:
exec p_i_general_yesterday '13974509','小雨卓'
union all
exec p_i_general_yesterday '13974509','小雨卓'
union all
exec p_i_general_sevenday'13974509','小雨卓'
create table t
(....)
insert into t
exec p_i_general_today '13974509','小雨卓'
insert into t
exec p_i_general_yesterday '13974509','小雨卓'
insert into t
exec p_i_general_sevenday'13974509' '13974509','小雨卓' select * from t
insert t
select exec p_i_general_yesterday '13974509','小雨卓' union all
select exec p_i_general_yesterday '13974509','小雨卓' union all
select exec p_i_general_sevenday'13974509','小雨卓'