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