sql—如何从临时表中读取多个值并将其赋给变量

xfyts7mz 于 2021-08-01 发布在 Java

关注(0)|答案(1)|浏览(350)

在我的select语句中有以下变量@memberid，其中memberid=@memberid，我想分配@notin temp表中的所有结果。有什么意见吗？

Create Table #NotIN(
     MemberId int);
   insert Into #NotIN
     select MemberId
     from Member
     where  CLIENtID = 19800 AND MemberID NOT IN (
     SELECT Distinct MemberID
     FROM [OnDemand].[dbo].[DealerVaultSale]
      where ClientID = 19800
          Union
      SELECT Distinct MemberID
      FROM [OnDemand].[dbo].[DealerVaultService]
      where ClientID = 19800 )
    Select * from #NotIN;
  SELECT [CustomerNumber]
      ,[ClientID]
      ,[MemberID]
      ,[LastImportDateTime]
       FROM [DealerVaultCustomerMemberMap] WHERE MemberID = @MemberID

我能做这个吗

declare @MemberID int
 set @MemberID = (Select * from #NotIN)

sql sql-server tsql

来源：https://stackoverflow.com/questions/62682036/how-to-read-multiple-value-from-a-temp-table-and-assign-it-to-a-variable

1条答案

按热度按时间

rm5edbpk1#

可以通过将sql与主表连接起来来实现这一点。

SELECT [CustomerNumber]
      ,[ClientID]
      ,[MemberID]
      ,[LastImportDateTime]
       FROM [DealerVaultCustomerMemberMap] a JOIN 
(select MemberId
     from Member
     where  CLIENtID = 19800 AND MemberID NOT IN (
     SELECT Distinct MemberID
     FROM [OnDemand].[dbo].[DealerVaultSale]
      where ClientID = 19800
          Union
      SELECT Distinct MemberID
      FROM [OnDemand].[dbo].[DealerVaultService]
      where ClientID = 19800 )) b ON  a.member_id = b.member_id;

赞(0）回复(0）举报 2021-08-01

我来回答

sql—如何从临时表中读取多个值并将其赋给变量

1条答案

相关问题

热门标签

最新问答