sp_executesql using cursor

truncate table SQLtoExec

drop table SQLtoExec

create table SQLtoExec (

sqlTEXT varchar(120) NOT NULL

-- , VendorCompanyId int NOT NULL

-- , fyenddate varchar(20) NOT NULL

)

INSERT INTO SQLtoEXEC

SELECT 'DELETE FROM vendorfinancecolumnar WHERE vendorcompanyid = '+ ltrim(str(vendorcompanyid)) + ' AND fyenddate = '''+ ltrim(cast(fyenddate as varchar(100))) + '''' 

FROM vendorfinancecolumnar 

WHERE vendordataperiodid = (

select vendordataperiodid 

from vendordataperiod

where vendorproviderid = 3 

and dataperiodid = 51)

GROUP BY vendorcompanyid, fyenddate

HAVING count(vendorcompanyid) > 1

DECLARE @sqlText nvarchar(120)

-- ########################################################################

DECLARE myCursor CURSOR FORWARD_ONLY READ_ONLY FOR

SELECT top 1000 sqlText

FROM sqlToEXEC

OPEN myCursor

     FETCH NEXT FROM myCursor

     INTO @sqlText

    

     WHILE @@FETCH_STATUS = 0

     BEGIN    

         

 EXECUTE sp_executesql @sqlText

                                               

          -- Get the next record.

          FETCH NEXT FROM myCursor

          INTO @sqlText

     END

CLOSE myCursor

DEALLOCATE myCursor

--drop table #myTable