SQL Server - how to get EXEC Pattern 10 ? - Asked By ali shaik on 30-Oct-13 09:58 PM

hi, 

  how to get  EXEC Pattern 10 ?? i written the following code getting the result as declare @x int,@y int

select @x=10,@y=0

while

@x>0

begin

print

space(@x)+replicate('1',@y)+replicate('1',@y+1)

set

@y=@y+1

set

@x=@x-1

end

select

@x=0,@y=9

while

@y>0
begin
print space(@x+2)+replicate('1',@y)+replicate('1',@y-1)
set @y=@y-1
set @x=@x+1
end