Try this one:
declare @table_name varchar(50)
declare @applicant int
declare @strSql Nvarchar(500)
declare curTable cursor for
SELECT TableName FROM tblIndexTable
open curTable
FETCH NEXT FROM curTable into @table_name
While (@@FETCH_STATUS=0)
begin
set @strSql = 'set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.