View Full Version : Stored Procedure involving dates


MATAdmin
01-13-2006, 10:15 AM
I have a rather large table that I need to run a stored procedure on to get the records in which there is a date span greater than two years. In other words, I want all the records after 12/1/2005 in which there was not an order (not a record) placed previously for over two years. How should I go about doing that?

Matt Greatorex
01-13-2006, 10:45 AM
What are the fields in the table and (briefly) what do they hold?

MATAdmin
01-17-2006, 07:22 AM
There is the ID #, School Name, City, State, and what they ordered.