Post reply

STored Procedure

  • October 30, 2018 at 9:53 am

    #380620

    Hi
      How the below code works
    SELECT ROW_NUMBER() OVER
    Thanks
      (
        ORDER BY [EmployeeID] ASC
      )AS RowNumber
      ,[EmployeeID]
      ,[FirstName] + ' ' + [MiddleName] + ' ' + [LastName] as FullName
         
      INTO #Results
      FROM [Employee]

  • October 30, 2018 at 10:10 am

    #2011714

    This explains it in detail

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply