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
Insert data into a table using table variables and cross join
最新推荐文章于 2022-10-05 15:13:28 发布