如何从临时表中获取最近插入的列的值？

渝风吹拂

我无法在Select语句中使用表的最近插入的Quantity值#ACCT来像
3 a' K% ]+ L) j2 k3 Jser.ServiceRate * Quantity
每次我得到错误
$ h/ N% E: U; d! e4 r! L/ A8 I
; B. J* a% s/ W  Y' F1 p5 g: t无法将值NULL插入“金额”列中
) h) [2 v5 R9 Q% P
8 U' V( |2 k' l我只是一个初学者，所以解决这个问题的任何指示都将有所帮助。
DECLARE @MinReservationId INT = (SELECT MIN(f.ReservationId) FROM dbo.Reservation AS f)
% U# a- h8 r! `; U  |2 YDECLARE @MaxReservationId INT = (SELECT MAX(f.ReservationId) FROM dbo.Reservation AS f)
DECLARE @QuantityNew INT
WHILE @MinReservationId  I WANT THIS VALUE TO BE USED BELOW
0 e1 G  t6 n# I: A9 a    )
: ^1 g+ C6 A. z% W9 d    INSERT INTO dbo.[Transaction]
8 A4 @/ x6 X+ Q& `. p* ?4 ^7 i(
+ s5 ]7 o% @% f% A! y& L# q9 c    ReservationId,
    ServiceId,
    Rate,
    Quantity,
    Amount      
0 v8 v8 [9 w5 S1 f)   
! Y4 {+ q# t( ?3 J5 S( ZOUTPUT inserted.ServiceId,Inserted.Quantity
INTO #Acct
(
    ServiceId,
    Quantity
)
SELECT
( i( z* y- R! i    @MinReservationId,
# f. }1 S$ E7 k    ser.ServiceId,
$ x% u! @# `6 |9 x, s    ser.ServiceRate,
* U. j3 |1 x! Z, o8 L' g    ABS(CHECKSUM(NEWID())%3) + 1,
: q5 D" k$ s- R# e7 ^    ser.ServiceRate * (SELECT acc.Quantity from #Acct as acc) -> QUANTITY from #ACCT should be used here
7 y2 i' v8 G& O9 D& ~# YFROM dbo.[Service] AS ser
SELECT @MinReservationId=@MinReservationId+1
; S0 ^  ~" L4 c, X+ SDrop table #Acct
END
               
解决方案: