STored Procedure

• jsshivalik

  SSChasing Mays

  Points: 612

  More actions

  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]

• drew.allen

  SSC Guru

  Points: 76997

  More actions

  October 30, 2018 at 10:10 am

  #2011714

  This explains it in detail

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA