Divide, Insert a string and append a number from t

Stuart Stalker · April 11th, 2006, 02:29 PM

Do I just think about doing things in a strange way? Or are these really difficult questions?

I have a number from a table lets say 8000
I need to divide the 8000 by another number lets say 50

8000 / 50 = 160

Then I need to insert a string into another table 160 times appending a number to the end, starting at 1 and ending at 160

I have not got a clue where to start.. has anyone else?

Stuart

Kep · April 11th, 2006, 06:58 PM

You could try something like this:-

Code:

DECLARE @loop INTEGER
DECLARE @loop_hi INTEGER

CREATE TABLE #numbers (
    row_name VARCHAR(30)
)

SELECT @loop = 1,
        @loop_hi = 8000 / 50

WHILE @loop <= @loop_hi
BEGIN
    INSERT INTO #numbers
        (row_name)
        VALUES('some string' + CAST(@loop AS VARCHAR(20)))

    SELECT @loop = @loop + 1
END

Although you probably need to limit the number of loops.

As to whether there is a better way I'd have to know more details about the problem.

Kep.