CREATE PROC [dbo].[CreateChunkSegment]
    @SnapshotId UNIQUEIDENTIFIER ,
    @IsPermanent BIT ,
    @ChunkId UNIQUEIDENTIFIER ,
    @Content VARBINARY(MAX) = 0x0 ,
    @StartByte BIGINT ,
    @Length INT = 0 ,
    @LogicalByteCount INT = 0 ,
    @SegmentId UNIQUEIDENTIFIER OUT
AS
    BEGIN
        DECLARE @output TABLE
            (
              SegmentId UNIQUEIDENTIFIER ,
              ActualByteCount INT
            );
        DECLARE @ActualByteCount INT;
        IF ( @IsPermanent = 1 )
            BEGIN	
                INSERT  Segment
                        ( Content )
                OUTPUT  inserted.SegmentId, DATALENGTH(inserted.Content)
                        INTO @output
                VALUES  ( SUBSTRING(@Content, 1, @Length) );
		
                SELECT TOP 1
                        @SegmentId = SegmentId ,
                        @ActualByteCount = ActualByteCount
                FROM    @output;
		
                INSERT  ChunkSegmentMapping
                        ( ChunkId ,
                          SegmentId ,
                          StartByte ,
                          LogicalByteCount ,
                          ActualByteCount
                        )
                VALUES  ( @ChunkId ,
                          @SegmentId ,
                          @StartByte ,
                          @LogicalByteCount ,
                          @ActualByteCount
                        );
            END
        ELSE
            BEGIN
                INSERT  [ReportServerTempDB].dbo.Segment
                        ( Content )
                OUTPUT  inserted.SegmentId, DATALENGTH(inserted.Content)
                        INTO @output
                VALUES  ( SUBSTRING(@Content, 1, @Length) );
		
                SELECT TOP 1
                        @SegmentId = SegmentId ,
                        @ActualByteCount = ActualByteCount
                FROM    @output;
		
                INSERT  [ReportServerTempDB].dbo.ChunkSegmentMapping
                        ( ChunkId ,
                          SegmentId ,
                          StartByte ,
                          LogicalByteCount ,
                          ActualByteCount
                        )
                VALUES  ( @ChunkId ,
                          @SegmentId ,
                          @StartByte ,
                          @LogicalByteCount ,
                          @ActualByteCount
                        );
            END
    END