set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER TRIGGER [BTEMP_INS] on [dbo].[BTEMP]
 AFTER INSERT AS

Declare
@TUID          int, 
@TMONEY        int, 
@TIFLAG        char(1), 
@TANAME          varchar(20),
@ACOUNT         INT,
@CMONEY         INT

BEGIN
 select @TUID = UID from inserted
 select @TMONEY = AMONEY from inserted
 select @TIFLAG=IFLAG from inserted 
 select @TANAME =ANAME from inserted
    select @Acount=0

 SELECT COUNT(*) AS ACOUNT, SUM(AMONEY) AS AMONEY
            FROM ATEMP WHERE UID=@TUID

-- 여기서 카운트를 알아야 하는데 계속 카운트가 엉뚱한거로 들어가네요.. ㅠ.ㅠ;

    if @ACOUNT<>0
 BEGIN
       select AMONEY AS CMONEY FROM ATEMP WHERE UID=@TUID
    select @TMONEY=@CMONEY+@TMONEY
    UPDATE ATEMP SET AMONEY =@CMONEY where UID=@TUID
 END
 ELSE IF @ACOUNT=0
 BEGIN
      INSERT INTO ATEMP(ANAME, AMONEY, IFLAG) VALUES(@TANAME,@TMONEY,@TIFLAG)
    END
   
END