Re: [Emerald] SQL Database Transfers

Dale E. Reed Jr. ( (no email) )
Mon, 23 Nov 1998 23:28:30 -0800

Glen Harvy wrote:
>
> I feel that after a week we are nearly there :-)
>
> Here's the results of running the original script:-
> Msg 213, Level 16, State 4
> Insert error: column name or number of supplied values does not match table definition.
>
> For the sake of completeness, here's what I believe to be the original script:-

Select @ast=i.AcctStatusType From inserted i

IF @ast = 2
BEGIN
Insert INTO CallDetails
Select DateAdd(Second, 0-i.AcctDelayTime, i.CallDate), i.UserName,
i.AcctSessionTime, i.FramedAddress, i.NASIdentifier, i.CallerID