It's just a matter of creating the table, then inserting into it
Create Table
CREATE TABLE #CampAlloc (
[TitleID] [int] NOT NULL ,
[SupplierID] [int] NOT NULL ,
[RecordingCompanyID] [int] NULL
) ON [PRIMARY]
Insert Data
INSERT INTO #CampAlloc
SELECT TitleID, SupplierID, RecordingCompanyID
FROM CampaignAllocation
WHERE CampaignID = @CampaignID
what problem are you getting, any error message?