Not Selecting All Columns in select query

• vaibhav.a

  SSChasing Mays

  Points: 639

  More actions

  August 3, 2009 at 10:17 pm

  #134561

  I am having one temporary table with dynamic columns..... means numbers of columns changes as per conditions.

  when i m using select query like:

  "SELECT * FROM ##Temp123;"

  but i dont want that all columns will come. I am knowing the column names which i dont want that they come, but dont know how to stop them for coming while using select query.

  Please help me

  Thanks in advance:-)

• Elliott Whitlow

  SSC Guru

  Points: 102296

  More actions

  August 3, 2009 at 10:39 pm

  #1034067

  SELECT columnname1, someothercolumnname, yetanothercolumnname

  FROM ##Temp123

  Clear?

  CEWII