Please take heed of the requests for sample data, in a consumable format (see the link in my signature for details).
And when you provide desired results, make them match...

Just to clear things up a little. An object variable is used to hold a full result set and this is what drives the number of iterations of the FOREACH...

Did you even try? It's not a great leap from what I posted.
CREATE TABLE dbo.NPI100
(
NPI VARCHAR(10) NOT NULL
, EntityTypeCode VARCHAR(1) NULL
);

After removing all the 'fluff', it would look something like this:

CREATE TABLE dbo.NPI100
(
  NPI VARCHAR(10) NOT NULL
, EntityTypeCode VARCHAR(1) NULL
);
GO

ALTER...

You could try BULK INSERT using the FIRSTROW qualifier. Looks promising, but I've not tried using it myself.