Without trying it(edit it didn't this does), this should work:
DO NOT DROP YOUR REAL TABLES AT THE END!
CREATE TABLE #resourcelocation
(
resourceid VARCHAR(50),
LOCATION VARCHAR(50)
);
INSERT INTO #resourcelocation
VALUES ('1',null),
('2',null),
('3',null) ;
CREATE TABLE...