T-SQL Problem... [?]

• Grognardo

  Grasshopper

  Points: 13

  More actions

  February 18, 2002 at 8:35 pm

  #101080

  Help?!?

  This is a school Assignment so hints or Pseudo-Code only please...

  The Assignment:

  Write a stored procedure returning the oldest employee hired by Northwind Traders. Do this without using the MIN() MAX() or COUNT() functions

  Output should be as follows; The oldest employee at the time they were hired was [Firstname]

  [lastname], who has been with the company for [x] years, [Y] months and [z] days

  

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 19, 2002 at 4:05 am

  #424098

  Hint think about the order of the data and what you can do with it and how you can get the first record out of a data set.