Система бизнес-аналитики Stimulsoft | Форум

Код: Выделить всё

/*insert data into #CalcNode table*/
IF Object_id('tempdb..#CalcNode') IS NOT Null DROP TABLE #CalcNode

CREATE TABLE #CalcNode(
    NodeId BIGINT NOT NULL,
    NodeName VARCHAR(100) NOT NULL,
    NodeParentId BIGINT NULL    
)

DECLARE @maxCount BIGINT,
        @count BIGINT,
        @parentId BIGINT;   
     
SET @maxCount = 5;
SET @count = 1;

WHILE @count <= @maxCount
BEGIN
    If @count = 1
        SET @parentId = NULL;
    ELSE
        SET @parentId = @count - 1;
        
    INSERT INTO #CalcNode(NodeId, NodeName, NodeParentId)
        VALUES (@count, 'Node_' + CONVERT(VARCHAR(400), @count), @parentId)
    SET @count = @count + 1;
END

SELECT * FROM #CalcNode

Код: Выделить всё

/*insert random data into #CalcNodeExpend table*/

IF Object_id('tempdb..#CalcNodeExpend') IS NOT Null DROP TABLE #CalcNodeExpend

CREATE TABLE #CalcNodeExpend(
    ExpendId BIGINT IDENTITY(1,1) NOT NULL,  
    NodeId BIGINT NOT NULL,
    Expend float NULL    
)

DECLARE @maxCount BIGINT

SELECT @maxCount = MAX(NodeId) FROM #CalcNode

INSERT INTO #CalcNodeExpend(NodeId, Expend)
SELECT 1 + ABS(CHECKSUM(NewId())) % @maxCount, ABS(CHECKSUM(NewId())) % 1000
FROM #CalcNode t1
JOIN #CalcNode t2 ON t2.NodeId <3

SELECT * FROM #CalcNodeExpend ORDER BY NodeId