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.

I'm assuming that your intention is to run an SSIS job on a schedule, say every hour, and to somehow detect which of the laptops are connected and which are...