BEGIN
DECLARE @iMin INT;
DECLARE @iMax INT;
DECLARE @table TABLE
(
[ID] INT IDENTITY(1, 1) ,
ColumnA DECIMAL(18, 4) ,
ColumnB DECIMAL(18, 4) ,
ColumnC VARCHAR(50) ,
ColumnD TINYINT
);
INSERT INTO @table
SELECT ColumnA1 ,
ColumnB1,
ColumnC1,
ColumnD1
FROM @TempTableSET @iMin = 1;
SELECT @iMax = MAX(ID)
FROM @table;
WHILE @iMin <= @iMax
BEGIN
DECLARE @ColumnA DECIMAL(18, 4);
DECLARE @ColumnB DECIMAL(18, 4);DECLARE @ColumnC VARCHAR(MAX);
DECLARE @ColumnD TINYINT;SELECT TOP 1
@ColumnA = ColumnA,
@ColumnB= ColumnB,
@ColumnC= ColumnC,
@ColumnD= ColumnDFROM @table
WHERE ID = @iMin;
/*
IF ( )
BEGIN
END;
ELSE
BEGIN
END;
*/
SET @iMin = @iMin + 1;
END;
END;