Database

DECLARE  @i AS INT<br />
SET @i=0<br />
<br />
DECLARE  @j AS INT<br />
SET @j=1<br />
<br />
DECLARE @kosova AS VARCHAR(255)<br />
SET @kosova=''<br />
<br />
WHILE(@i<10)<br />
BEGIN<br />
	WHILE(@j<@i)<br />
	BEGIN<br />
		SET @kosova=@kosova+CAST(@i AS VARCHAR(10))<br />
		<br />
		SET @j=@j+1	<br />
	END<br />
	PRINT @kosova<br />
	set @kosova=''<br />
	SET @j=0<br />
	SET @i=@i+1<br />
END

   1
  222
 33333
4444444

I are troll

         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.