Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
6
Reply
SQL to Linq query [Inner Join]
Vijay
Mar 24 2014 6:31 AM
1.2k
Reply
How to write SQL to Linq Query [i.e.Inner Join]
SELECT * FROM Products pp WITH (NOLOCK)
INNER JOIN (SELECT TOP 1 Shiftdate,ShiftID, Period FROM Products WITH (NOLOCK)
WHERE ProuductId =100 AND OrderId =5 ORDER BY Shiftdate DESC, ShiftID DESC,Period DESC) ss
ON pp.Shiftdate = ss.Shiftdate AND pp.ShiftID = ss.ShiftID AND pp.Period = ss.Period
WHERE ProuductId = 100 AND OrderId = 5 ORDER BY DelyId
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
WCF | The formatter threw an exception while deserializing
How Many Request a WCF Service Can Process