Searching records by date

[song2siren]

Hello

I've got a date field in a SQL database (PubDate) and I just need to know how to retrieve records using a stored procedure depending on whether the date is either this month or last month.

The search parameter for this month or last month is passed to the stored procedure from a dropdown list on an aspx page.

I think this should be fairly simple but any suggestions would be much appreciated.

Thanks

 

[jgoodman00]

CREATE PROCEDURE SomeProc(@SomeVal int)
--Pass 0 in for current month, 1 in for last month
SELECT * FROM SomeTable
WHERE DATEDIFF(m,SomeDate,GETDATE()) = @SomeVal

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com