Returning row count as output in CTE

Question

Returning row count as output in CTE

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

brendan woulfe Hall of Fame Points: 3888 More actions · Answer 1

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 · Answer 2

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