ALTER proc Get_adjscx
(
@bt varchar(4),
@ddid varchar(30),
@zdid varchar(30),
@Bdate varchar(10),
@Edate varchar(10)
)
as
DECLARE @SqlStr varchar(200)
Set @SqlStr='select * from bl_idx where BDate>='''+@BDate+''' and Bdate<='''+@EDate+''''
select @SqlStr if @bt<>''
Set @SqlStr=@SqlStr+' and bt='+@bt
if @ddid<>''
Set @SqlStr=@SqlStr+' and ddid='+@ddid
if @zdid<>''
Set @SqlStr=@SqlStr+' and zdid='+@ddid
exec(@SqlStr)
go
(
@bt varchar(4),
@ddid varchar(30),
@zdid varchar(30),
@Bdate varchar(10),
@Edate varchar(10)
)
as
DECLARE @SqlStr varchar(200)
Set @SqlStr='select * from bl_idx where BDate>='''+@BDate+''' and Bdate<='''+@EDate+''''
select @SqlStr if @bt<>''
Set @SqlStr=@SqlStr+' and bt='+@bt
if @ddid<>''
Set @SqlStr=@SqlStr+' and ddid='+@ddid
if @zdid<>''
Set @SqlStr=@SqlStr+' and zdid='+@ddid
exec(@SqlStr)
go
Set @SqlStr='select * from bl_idx where BDate>='''+@BDate+''' and Bdate<='''+@EDate + ''''