CREATE PROC PROC_NAME
@Plan_Notice INT
AS
IF Plan_Notice=1
Select * from table
ELSE IF Plan_Notice=2
Select * from table where Plan_Notice=2
ELSE IF Plan_Notice=3
Select * from table where Plan_Notice_Date='getdate()'
ELSE IF Plan_Notice=4
Select * from table where DateDiff(dd,getdate(),Plan_EndTime)>Plan_Notice_Day
@Plan_Notice INT
AS
IF Plan_Notice=1
Select * from table
ELSE IF Plan_Notice=2
Select * from table where Plan_Notice=2
ELSE IF Plan_Notice=3
Select * from table where Plan_Notice_Date='getdate()'
ELSE IF Plan_Notice=4
Select * from table where DateDiff(dd,getdate(),Plan_EndTime)>Plan_Notice_Day
(@Plan_Notice int)
as
begin
if Plan_Notice=1
Select * from table
else if Plan_Notice=2
Select * from table where Plan_Notice=2
else ifPlan_Notice=3
Select * from table where Plan_Notice_Date='getdate()'
else ifPlan_Notice=4
Select * from table where DateDiff(dd,getdate(),Plan_EndTime)>Plan_Notice_Day
end
(@Plan_Notice int)
as
begin
if @Plan_Notice=1
Select * from table
else if @Plan_Notice=2
Select * from table where Plan_Notice=2
else if @Plan_Notice=3
Select * from table where Plan_Notice_Date='getdate()'
else if @Plan_Notice=4
Select * from table where DateDiff(dd,getdate(),Plan_EndTime)>Plan_Notice_Day
end
(@Plan_Notice int)
as
begin
if Plan_Notice=1
Select * from table
else if Plan_Notice=2
Select * from table where Plan_Notice=2
else ifPlan_Notice=3
Select * from table where Plan_Notice_Date='getdate()'
else ifPlan_Notice=4
Select * from table where DateDiff(dd,getdate(),Plan_EndTime)>Plan_Notice_Day
end
declare @Plan_Notice int
declare my_curosr cursor for
select * from table1open my_curosrfetch next from my_curosr
into @Plan_Notice
while @@fetch_status = 0
begin if @Plan_Notice=1
Select * from table1
else if @Plan_Notice=2
Select * from table1 where Plan_Notice=2
else if @Plan_Notice=3
Select * from table1 where Plan_Notice_Date='getdate()'
else if @Plan_Notice=4
Select * from table1 where DateDiff(dd,getdate(),Plan_EndTime)>Plan_Notice_Day fetch next from my_curosr
into @Plan_Notice
end