ALTER PROCEDURE [dbo].[effburstwo] @wo int,@opsq float,@fromdate varchar(25),@thrudate varchar(25),@shift char(1),
                            @wc char(12) AS
declare @strsqlshift varchar(65)
declare @strwo varchar(8)
declare @stropsq varchar(15)

select @strwo=convert(varchar(8),@wo),
@stropsq=convert(varchar(15),@opsq)

select @strsqlshift=
case
when @shift<>'*' then "and a.wtapid='"+@shift+"'"
else ""
end

exec("
select a.wtan8,b.abalph,a.wthrw,
case
 when a.wttyr='1' then 'RUN'
 when a.wttyr='2' then 'SETUP'
 when a.wttyr='3' then 'CANCEL'
 when a.wttyr='4' then 'QTY'
 else '*'
end trantype,wtapid,wtsoqs,wtsocn,wtyst,wtdgl
from ibmprod.dbo.f31122 a, ibmprod.dbo.f0101 b
where a.wtan8=b.aban8 and a.wtdoco="+@strwo+
" and a.wtdgl between '"+@fromdate+"' and '"+@thrudate+"' and wtopsq="+@stropsq+" "+@strsqlshift+
" and a.wtmcu='"+@wc+"' order by wtdgl ")