Insert data into a table using table variables and cross join
来源:互联网 发布:网络协议分析 pdf 编辑:程序博客网 时间:2024/05/19 16:34
Declare @SSRSreportIDTable TABLE(ID int)Declare @UserNameTable Table(username nvarchar(50))INSERT INTO @SSRSReportIDTable Select SSRSReportID FROM SSRSReportWHERE SSRSReport.[SSRSReportID] != 23 and SSRSReport.[SSRSReportID] != 24INSERT INTO @UserNameTable select UserName FROM [users] where [Username] like '%@%'INSERT INTO UserToSSRSReport(UserName, SSRSReportID)select Username, idFROM @SSRSReportIDTable cross join @UserNameTableselect * from UserToSSRSReport
0 0
- Insert data into a table using table variables and cross join
- Insert Data into Sorted Table
- Insert Data into Sorted Table
- SQL Server Insert data into table
- jquery insert a table into div
- Azure Basic - Insert data into BlockBlob, Table and Queue (with Diagnostic + Azure Storage Explore)
- Using Data and Variables
- SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
- convert the Data from Table into Insert Sentence.
- Using Data Table Mappings
- Mysql select data from one table into a new one
- BIRT是否完善支持对存在Computed Column的Join Data Set生成Cube/Cross Table?
- insert into table 插入多条数据
- VC insert into table() values(变量)
- insert into table 插入多条数据
- SQLite Insert Multiple Records into table
- insert into table 插入多条数据
- How to store a 1D table data into a general data structure?
- maven + eclipse 问题记录
- Sublime Text 3 快捷键
- 2012年"浪潮杯"山东省第三届ACM大学生程序设计竞赛——Pixel density
- windows安装Apache
- Java提高 - 八大排序方法之直接插入排序
- Insert data into a table using table variables and cross join
- BZOJ 1103: [POI2007]大都市meg
- 多态,动态类型,动态绑定
- 四、Html常用标签
- Javaweb Dom4j解析XMl
- 常见OJ评判结果对照表
- Ubuntu12.04(X86_64)上安装Mesa-8.0.4
- PL/SQLdevelop登入oracle数据库很慢
- LinearLayout中组件右对齐