Database

         0
        111
       22222
      3333333
     444444444
    55555555555
   6666666666666
  777777777777777
 88888888888888888
9999999999999999999

DECLARE @R AS INT
SET @R = 0
DECLARE @FILL AS INT
SET @FILL = 10
DECLARE @NUMCNT AS INT
SET @NUMCNT = 1

DECLARE @ROWSTR AS VARCHAR(100)
DECLARE @I AS INT

WHILE (@R < 10)
BEGIN
      SET @ROWSTR = ''

      SET @I = 0
      WHILE (@I < @FILL)
      BEGIN
            SET @ROWSTR = @ROWSTR + ' '
            SET @I = @I + 1
      END

      SET @I = 0
      WHILE (@I < @NUMCNT)
      BEGIN
            SET @ROWSTR = @ROWSTR + CAST(@R AS VARCHAR)
            SET @I = @I + 1            
      END

      SET @R = @R + 1
      SET @FILL = @FILL - 1
      SET @NUMCNT = @NUMCNT + 2

    PRINT @ROWSTR
END

I are troll

        1
       2 2
      3 3 3
     4 4 4 4
    5 5 5 5 5
   6 6 6 6 6 6
  7 7 7 7 7 7 7
 8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

         0
        111
       22222
      3333333
     444444444
    55555555555
   6666666666666
  777777777777777
 88888888888888888
9999999999999999999

I are troll

Mustafa Ismail Mustafa wrote:

What I'm looking for is like source control for DB but atop all the scripts I'd like to move the data around as well.