• Here you go

    CREATE PROCEDURE [dbo].[VD_TEMP_0506] AS

    DECLARE @DB varchar(25)

    create table #t ([name] varchar(50))

    insert into #t

    SELECT [Name]

    FROM master.dbo.sysdatabases

    Where [name] like '%NCR%'

    order by [Name]

    DECLARE DBCursor CURSOR FOR

    (

    SELECT [Name]

    FROM #t

    )

    OPEN DBCursor

    FETCH NEXT FROM DBCursor INTO @DB

    WHILE @@fetch_status = 0

    BEGIN -- WHILE BEGIN

    PRINT @DB

    FETCH NEXT FROM DBCursor INTO @DB

    END -- WHILE END

    CLOSE DBCursor

    DEALLOCATE DBCursor

    GO