sCursor1 = "DECLARE @num_dog varchar(13), @num_dog_pr varchar(13), @dog varchar(13) " & _
             "Declare c0 CURSOR FOR " & _
             "SELECT distinct num_dog FROM " + sTblName + "rez " & _
             "OPEN c0 FETCH NEXT FROM c0 INTO @num_dog " & _
             "WHILE @@FETCH_STATUS = 0 " & _
            "BEGIN " & _
                "DECLARE c1 CURSOR FOR " & _
                "SELECT distinct num_dog_pr FROM dstrah..dog_in where num_dog = @num_dog and " & _
                "isNull(num_dog_pr,'')<>'' and num_dog<>isNull(num_dog_pr,'') " & _
                "OPEN c1 FETCH NEXT FROM c1 INTO @num_dog_pr " & _
                "WHILE @@FETCH_STATUS = 0 " & _
"BEGIN " & _
                "insert into " + sTblName + "cntProlong1" + "  (num_dog,num_dog_pr,num_row) values (@num_dog,@num_dog_pr,1) " & _
                "FETCH NEXT FROM c1 INTO @num_dog_pr " & _
                "End Close c1 DEALLOCATE c1 " & _
             "FETCH NEXT FROM c0 INTO @num_dog " & _
            "End Close c0 DEALLOCATE c0"
conn.Execute (sCursor1)