passing data into SP from DDL 1

[zzzzzeke]

do i have to use parameters to pass data into a SP?

i'm trying to take a date value from a drop down list and running a query based on that date.

 

[nigelrivett]

>> May 27, 2004
do i have to use parameters to pass data into a SP?

The SP will receive the data as a parameter.

You can pass it as a datetime parameter or as a character parameter or as part of the exec string - if so use yyyymmdd format.


======================================
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.

 

[zzzzzeke]

Show shipped sales within the past (DDL otpions: 1 7 30 60 90 180 All) days

how will i go about the SQL statement?

SELECT *
FROM orders
WHERE (shipping_status = 'shipped')

shipped_date is what i'm wanting to compare against.....


so will i have to get todays date, and -180 if 180 days is selected from the DDL?

 

[nigelrivett]

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.

 

[zzzzzeke]

Thanks nigelrivett, but I ended up using the DATEDIFF function.