TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Vijay
NA
150
90.4k
SQL to Linq query [Inner Join]
Mar 24 2014 6:31 AM
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
Reply
Answers (
6
)
WCF | The formatter threw an exception while deserializing
How Many Request a WCF Service Can Process