IIRC, the table variable is preferred to temp tables. Similar syntax:
DECLARE @temp2 TABLE (JobID int,winnerId int,Title Nvarchar(50),FirstName nvarchar(50),LastName nvarchar(50),
Destination nvarchar(50),DateBooked datetime,DateDeparture datetime,Operators nvarchar(50),PhoneHome nchar(25),
PhoneWork nchar(25),Address nvarchar(200),TCAT nvarchar(50),Notes nvarchar(50),LastModifiedBy nvarchar(50),LastModifiedDate datetime);
Now no need to drop
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane