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 for
> the
> >> most efficient way to get rid of call table records while still keeping
> data
> >> on total time logged in. I was thinking maybe one record per user per
> month
> >> with total time? I'm interested in hearing how other people handle call
> >> 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. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com