Stored Procedure involving dates (1 Viewer)

M

MATAdmin

New member

Local time

Yesterday, 18:54

Joined

Dec 9, 2005

Messages

7

• Jan 13, 2006

• #1

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

Registered User.

Local time

Yesterday, 21:54

Joined

Jun 22, 2005

Messages

1,019

• Jan 13, 2006

• #2

What are the fields in the table and (briefly) what do they hold?

 

M

MATAdmin

New member

Local time

Yesterday, 18:54

Joined

Dec 9, 2005

Messages

7

• Jan 17, 2006

• #3

There is the ID #, School Name, City, State, and what they ordered.