get a sorted query into a temp table

• dudeski1

  SSC Enthusiast

  Points: 119

  More actions

  May 7, 2002 at 12:28 pm

  #78145

  hi

  does anyone know how i can get a query into a temp table while having it sorted in the manner i wish?

  thanks!!

• Eve

  SSCrazy

  Points: 2480

  More actions

  May 7, 2002 at 12:52 pm

  #428636

  Just add Order By to your query, like:

  CREATE TABLE #tbltest

  (ROW_ID INTEGER IDENTITY(1,1)

  ,Client_Code int

  ,Client_name varchar(100)

  )

  insert #tbltest

  select Client_code,Client_name

  from tblClient where Date_Created >'05/01/2002'

  order by Client_Code