troubleshooting Question

first record in sql server

Avatar of chickanna
chickannaFlag for Afghanistan asked on
Microsoft SQL Server
6 Comments1 Solution512 ViewsLast Modified:
experts... I have a sybase query like this.

      select
            first @RecordStatusID = lm.RecordStatusID
      From
            it_systems.ft_ArchivedLoanBox alb
      left join
            it_systems.ft_ArchivedLoan al
      on
            (alb.ArchiveID = al.ArchiveID)
      left join
            ezadmin.ft_LoanMaster lm
      on
            (al.LoanID = lm.LoanID)
      where
            (alb.ArchiveBoxNum) = (@ArchiveBoxNum)


What is the equivalent function for "first" in SQL Server 2005/2008??
ASKER CERTIFIED SOLUTION
kaminda

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros