Importing plans from a user table

Use sp_import_qpgroup to copy plans from tables created by sp_export_qpgroup into a group in sysqueryplans. This example copies the plans from the table tempdb.mplans into ap_stdin, assigning the user ID for the database owner:

sp_import_qpgroup "tempdb..mplans", dbo, ap_stdin

You cannot copy plans into a group that already contains plans for the specified user.