*********** REPLY SEPARATOR ***********
On 6/4/98, at 12:56 PM, Dale E. Reed Jr. wrote:
>> What would be the SQL to do this with an access database.
>The same thing. AFAIK, select into is a standard SQL query.
>> *********** REPLY SEPARATOR ***********
>> On 6/4/98, at 11:48 AM, Dale E. Reed Jr. wrote:
>> >On Thu, 4 Jun 1998, Peter D. Mayer wrote:
>> >> Does anyone have a good call history script for MSSQL? I'm looking
>> >> most efficient way to get rid of call table records while still
>> >> on total time logged in. I was thinking maybe one record per user
>> >> with total time? I'm interested in hearing how other people handle
>> >> history.
>> >If you crreated a second table like "CallHistory" (like what Emerald
>> >uses) you could them do something like this:
>> >Select Username, CallDate='5/1/98', Mins=Sum(AcctSessionTime/60+1)
>> >Into CallHistory
>> >From Calls
>> >Where CalLDate >= '5/1/98'
>> > and CallDate < '6/1/98'
>> > and AcctStatusType = 2
>> >and then delete based on just the date range.
>Dale E. Reed Jr. (email@example.com)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
Internet - firstname.lastname@example.org