DECLARE @myTable table
(
myguid int identity(1,1),
clientName nvarchar(50),
transactionNumber int,
jobNumber nvarchar(500),
eventName nvarchar(500),
location nvarchar(500),
tier nvarchar(100),
movein datetime,
startdate datetime,
endtime datetime,
moveout datetime
)
INSERT INTO @myTable(
transactionNumber,
jobNumber,
eventName,
location,
tier,
movein,
startdate,
endtime,
moveout
)
SELECT
o.transactionNumber,
o.jobNumber,
o.eventName,
ei.location,
ei.tier,
o.shipToDeliveryDate,
ei.startDate,
ei.endDate,
ei.tearDownDate
FROM
onlineOrder AS o
INNER JOIN
eventInformation AS ei
ON o.jobNumber = ei.jobNumber
WHERE
(o.shipToDeliveryDate > '1/1/2012')
Do more with
Premium Content
You need an Expert Office subscription to comment.Start Free Trial