Figured it out 🙂

Thanks again. P

CREATE TABLE PS_Test

(

cnt varchar(255),

code varchar(255),

tn varchar(255),

);

--SELECT * FROM dbo.PS_Test

--GO

DECLARE @SQL nvarchar(max);

DECLARE @tbl TABLE (ID VARCHAR (255))

-- List of tables to checked

DECLARE cTables CURSOR LOCAL STATIC FORWARD_ONLY READ_ONLY

FOR

--SELECT N'SELECT TOP 1 * FROM ' + QUOTENAME( name) + N';' -- insert select in here

SELECT N'

insert into PS_Test (cnt, code, tn)

select count (*) as cnt, code,''' + QUOTENAME( name) + ''' as tn

FROM' + QUOTENAME( name) +

'group by code

having count (*) > 1 ' + N';'

FROM sys.views

WHERE (name LIKE '%vw_LocalDomain%') AND name NOT LIKE '%RIO_SPONT%'

ORDER BY name;

OPEN cTables;

FETCH NEXT FROM cTables INTO @SQL;

WHILE @@FETCH_STATUS = 0

BEGIN

EXEC( @SQL);

--INSERT @tbl SELECT @SQL

FETCH NEXT FROM cTables INTO @SQL;

END;

CLOSE cTables;

DEALLOCATE cTables;

GO

SELECT * FROM dbo.PS_Test

DROP TABLE dbo.PS_Test