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)