Returning row count as output in CTE

• brendan woulfe

  Hall of Fame

  Points: 3888

  More actions

  August 16, 2011 at 2:26 pm

  #1369324

  Read all the articles/links, good stuff. I'm going to try Eugene's suggestion of SELECT...INTO with UNION (I have duplicates in my data) and then try the key lookup solution as well and see what works best, performance wise. I'll let you know what I find, may take awhile. Looking at it now and it's around 1300 lines...:blink:

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  August 17, 2011 at 1:53 am

  #1369455

  Lowell (8/16/2011)

  ---

  ChrisM@Work (8/16/2011)

  ---

  Was it the key seek method, explained elegantly by Paul White here[/url]?

  that post from Paul exactly encapsulates that portion of his presentation Chris, yes.

  » Dmitri Korotkevitch's web site, now that i grabbed my notes, is http://aboutsqlserver.com but he has not posted his presentation materials from it yet.

  Thanks Lowell.

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden