Avatar of chickanna
Flag for Afghanistan

asked on 

first record in sql server

experts... I have a sybase query like this.

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

What is the equivalent function for "first" in SQL Server 2005/2008??
Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon