如果您仅对
Id
1和感兴趣
4，则可以在
INSERT查询中对其进行过滤
至于
Anonymous，您可以使用
case语句来完成
窗口函数
count(*) over()将为您提供查询结果中的总行数
Insert into @invoiceTable ( Id, CustName, FilteredRecords )Select Id = I.Id, CustName = CASE WHEN R.Name Like '%-%' then 'Anonymous' else R.Name end, FilteredRecords = count(*) over()from Invoice I Inner Join Customer R on I.CustomerId = R.Idwhere I.Id In (1,4)
