Your question, your audience. Choose who sees your identity—and your question—with question security.
SELECT TOP (100) PERCENT dbo.DataEntryView.ctJobID, dbo.DataEntryView.JobNum, dbo.DataEntryView.Part, dbo.DataEntryView.Contractor,
dbo.DataEntryView.Owner, dbo.DataEntryView.Sales_Initial, dbo.DataEntryView.Sales_Amount, dbo.DataEntryView.DesEng_SalesPerHour,
dbo.DataEntryView.loggedin, dbo.DataEntryView.Customer_Expected_Delivery, Bid_LF_Table.Bid_LF
FROM dbo.DataEntryView LEFT OUTER JOIN
(SELECT TOP (1) Actual_Start_Date AS Bid_LF, JobID
FROM dbo.DesEngSchedule AS DesEngSchedule_1
WHERE (Department LIKE 'Custom Design Engineering') AND (TaskName LIKE '02%')
ORDER BY Bid_LF) AS Bid_LF_Table ON dbo.DataEntryView.ctJobID = Bid_LF_Table.JobID
WHERE (dbo.DataEntryView.loggedin IS NOT NULL) AND (dbo.DataEntryView.Finalized_Sales >= GETDATE() - 7 OR
dbo.DataEntryView.Finalized_Sales IS NULL) AND (dbo.DataEntryView.bidresultdate IS NULL) AND (dbo.DataEntryView.Lost_Sales_Date IS NULL) AND
(dbo.DataEntryView.Sales_Initial NOT LIKE 'PD') AND (dbo.DataEntryView.Sales_Initial NOT LIKE 'CS')
select
tbl.*
from
YourTable tbl
inner join
(
Select
JobID,
max(ActualStartDate) as ActualStartDate
from
DataEntryView dev
group by
JobID
) maxdates
ON
maxdates.JobID=tbl.JobID
AND maxdates.ActualStartDate=tbl.StartDate
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join the community of 500,000 technology professionals and ask your questions.