Quick way to add drivers to boot images that are in one boot image but not in another

-- I know, not a good idea, but the console is just so sllloooooowwwww
-- Add drivers to XXX00035  that are in XXX00334
insert BootImgPkg_References (PkgID, CI_ID, SourcePath) select 'XXX00035', bip.CI_ID, bip.SourcePath from BootImgPkg_References as bip
INNER JOIN CI_ConfigurationItems as cc ON cc.CI_ID = bip.CI_ID
INNER JOIN v_CI_DriversCIs as drv ON drv.CI_ID = bip.CI_ID WHERE bip.PkgID = 'XXX00334'
and bip.CI_ID not in (
SELECT distinct bip.CI_ID
FROM BootImgPkg_References as bip
INNER JOIN CI_ConfigurationItems as cc ON cc.CI_ID = bip.CI_ID
INNER JOIN v_CI_DriversCIs as drv ON drv.CI_ID = bip.CI_ID WHERE bip.PkgID = 'XXX00035'
)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s