use ReportServerTempDB select *from dbo.ChunkData INNER JOIN [ChunkSegmentMapping] on ChunkSegmentMapping.ChunkId = ChunkData.ChunkID INNER JOIN [PersistedStream] on PersistedStream.SessionID = ChunkData.SnapshotDataID use ReportServerTempDB select *from dbo.Segment select *from dbo.ChunkData alter procedure selectsubquery as declare @department varchar(50) begin --select *from dbo.Segment where SegmentId = (select *from dbo.Segment where Content= @department) select * from SegmentId where emp_add =(select * from dbo.Segment where Content =@department) end exec selectsubquery "1" create view selectall as select *from Segment select *from selectall drop view selectall drop procedure selectsubquery create index test_index on ChunkData(SnapshotDataID) drop index ChunkData.test_index select *from dbo.Segment create database testdbset create table userse (userid int ,name varchar(50)) drop table users select * from users --insert into use...
Comments
Post a Comment