Insert data into a table using table variables and cross join

最新推荐文章于 2022-10-05 15:13:28 发布

wbing520

最新推荐文章于 2022-10-05 15:13:28 发布

阅读量585

点赞数

分类专栏： Database 文章标签： sql cross join table variable

本文链接：https://blog.csdn.net/luzin520/article/details/45372695

版权

Database 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

Declare @SSRSreportIDTable TABLE
(
	ID int
)
Declare @UserNameTable Table
(
	username nvarchar(50)
)

INSERT INTO @SSRSReportIDTable 
	Select 	SSRSReportID FROM SSRSReport
	WHERE SSRSReport.[SSRSReportID] != 23 and SSRSReport.[SSRSReportID] != 24

INSERT INTO @UserNameTable 	
select UserName FROM [users] where [Username] like '%@%'

INSERT INTO UserToSSRSReport
(UserName, SSRSReportID)
select Username, id
FROM 
@SSRSReportIDTable cross join @UserNameTable

select * from UserToSSRSReport