Query Joins

• jab

  Old Hand

  Points: 312

  More actions

  August 21, 2003 at 8:20 am

  #82828

  Hey All, quick question: has anyone ever hit a limit on the number of fields can be joined in a view? I am trying to do a query joining about 205 fields and I'm not getting any results (where there defintately should be) and no errors. Any ideas? TIA....

• NPeeters

  SSChampion

  Points: 12611

  More actions

  August 21, 2003 at 9:27 am

  #470801

  From BOL (for SQL2K)...

  quote:

  ---

  Remarks

  A view can reference a maximum of 1,024 columns.

  ---

  So that should not be the problem.

  Edited by - NPeeters on 08/21/2003 09:27:54 AM