DECLARE @c INT = 1, @PostURL VARCHAR(1000)
WHILE @c <= (SELECT COUNT(*) FROM FM_Magazine_WebSelection)
BEGIN
	SET @PostURL = (SELECT PostURL FROM FM_Magazine_WebSelection WHERE RowNumber = @c)
	EXEC usp_CLR_PostURL @PostURL
	SET @c = @c + 1
END

Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports System.Data.Sql
Imports System.IO
Imports System.Net
Imports System.Text
Imports System.Web
Imports System.Collections
Imports System.ComponentModel
Imports System.Text.RegularExpressions
Imports System.Diagnostics
Imports System.Web.Services


Partial Public Class StoredProcedures
    <Microsoft.SqlServer.Server.SqlProcedure()> _
    Public Shared Sub usp_CLR_PostURL(ByVal InStr As String)
        Dim request As HttpWebRequest

        Dim response As HttpWebResponse = Nothing
        Dim reader As StreamReader
        Dim URLString As String
        Dim address As Uri
        Dim returnstring As String

        URLString = InStr
        address = New Uri(URLString)
        request = DirectCast(WebRequest.Create(address), HttpWebRequest)
        request.Timeout = 1000000
        response = DirectCast(request.GetResponse(), HttpWebResponse)
        reader = New StreamReader(response.GetResponseStream())
        returnstring = reader.ReadToEnd

        Using connection As New SqlConnection("context connection=true")
            connection.Open()

            Dim command As New SqlCommand("SELECT '""" & Replace(returnstring, Chr(39), "") & """'", connection)
            SqlContext.Pipe.ExecuteAndSend(command)

        End Using

    End Sub
End Class

do you have a key column on your source data?

1. create temp db

create TABLE [dbo].migration_temp(KeyField int not null)
GO

2. Create a processing table that holds all rows that you want to move based on a key field

create table dbo.Process(keyFieldId int NOT NULL, isProcessed bit NOT NULL default((0)))


3. Dump into Process all unique keyField values

   insert into dbo.Process(keyFieldID)
   SELECT keyFieldID FROm SourceTableView


4.dump batch rows into temp table

		WHILE (SELECT COUNT(*) FROM dbo.Process WHERE isProcessed = 0) > 0

		INSERT INTO dbo.migration_temp(KeyField)
		SELECT TOP 100 KeyFieldID
		  FROM dbo.Process with (nolock)
		 WHERE isProcessed = 0



6. Batch process your code

7. Update process table

		 UPDATE tgt
			SET tgt.isProcessed = 1
		   FROM dbo.Process tgt  with (nolock)
		  inner join dbo.migration_temp src 
		  on src.KeyFieldID= tgt.KeyFieldID