Re: SQL Commands

Dale E. Reed Jr. ( (no email) )
Mon, 25 May 1998 13:04:57 -0700

> Kelly Wright wrote:
> My data base is about 150Megs big now. I was needing the SQL scripts to
> delete all call records and null calls and whatever else I can to skinny down
> the amout of space that is being used up.

Well, the simplest way is:

Delete From Calls
Where CallDate < '2/1/98'

replacing the date as needed.

You can get a list of Calls records per month doing this:

Select DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)