sql查询出多条数据如何保存,帮忙看下代码

ALTER trigger [dbo].[ICStockBill_RWHQ] on [dbo].[ICStockBill]
for insert
as
begin

update [dbo].[ICStockBill] 
set 
  [FHeadSelfB0436]=
  (select [FICMOInterID] from [ICStockBillEntry] where [dbo].[ICStockBillEntry].[FInterID]=(select [FInterID] from inserted))
  ---上面这个插入输入的值查询出来多条,SQL不能保存多条数据,也不能用数组,请大神们帮看看这个多条数据如何保存
FROM [dbo].[ICStockBill] a,[dbo].[ICStockBillEntry] b

--下面判断是否当次添加ID,单据类型是否为‘24’,根据当次ID查找明细表中存在多条[FInterID]项然后判断是否都为 ‘85’
where a.[FInterID]=(select [FInterID] from inserted)
and
(select a.[FTranType] where a.[FInterID]=(select [FInterID] from inserted))='24'
and
(select b.[FSourceTranType] where b.[FInterID]=(select [FInterID] from inserted))='85'
end

http://blog.csdn.net/happy_ddm/article/details/6792317

你先根据条件查出来多条数据的list ,然后循环这个list去做保存操作