Co-worker Dispute

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  January 22, 2009 at 9:53 am

  #931292

  That will not be a for a while. nice thing about an SP is if it gives me grief I can change it to a @Table and be done. thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 22, 2009 at 10:24 am

  #931306

  JKSQL (1/22/2009)

  ---

  That will not be a for a while. nice thing about an SP is if it gives me grief I can change it to a @Table and be done. thanks

  Use a temp table, not a table variable. With large rowcounts, table variables will not give you good performance when joined in to a query.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass