Home Forums SQL Server 2012 SQL 2012 - General The number of variables declared in the INTO list must match that of selected columns. RE: The number of variables declared in the INTO list must match that of selected columns.

  • Like this using Ed's code.

    WITH FinalDBUser(dbname, username) AS (

    Select

    dbname,

    username

    from

    dbo.FinalDBleverluser

    Order by

    dbname

    )

    SELECT @strSQL = @strSQL + 'use ' + QUOTENAME(dbname) + '; drop user ' + QUOTENAME(username) + '; '

    FROM FinalDBUser;

    SELECT @strSQL;