create proc GetResult
@NoDays int
as
SELECT *
FROM orders
WHERE shipping_status = 'shipped'
AND ( shipping_Date >= convert(varchar(8),dateadd(dd,@NoDays * -1, getdate()),112)
or @NoDays is null
)
go
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.