DECLARE @ResponseText nvarchar(max)
DECLARE @PageSize int
DECLARE @Counter INT
DECLARE @TotalPrints INT
DECLARE @Length int;

SET @PageSize = 2;
SET @Counter = 0
SET @ResponseText = '123456789'
SET @Length = LEN(@ResponseText)

IF((@Length % @PageSize) = 0)
    BEGIN
        SET @TotalPrints = (@Length / @PageSize)
    END
ELSE
    BEGIN
        SET @TotalPrints = (@Length / @PageSize) + 1
    END

WHILE @Counter < @TotalPrints 
    BEGIN
        PRINT SUBSTRING(@ResponseText, (@Counter * @PageSize)+1, @PageSize)
        SET @Counter = @Counter + 1
    END