Never seen that either. Interesting indeed.

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...

Eugene Elutin (8/16/2011)

Using...

They want it returned with an OUTPUT parameter from the stored procedure. It's setup with temp table right now and the performance is just ok. I may just...

Eugene, so the count is returned as a column in the resultset? I already tried something similar and it wasn't an accepted solution...:(

I never understood why not, but I'm...

Eugene has it right, it returns the number of records that were returned after paging. I need to know how many would have been returned had there been no...

Interesting solution. I'll have to try and wrap my head around that one. Not seeing how I would return the total count as an output parameter though? Wish...

Thanks for the response. I will give it a read!!

🙂

Gila answered one of my questions about the unique constraint/unique index already.

I do still have a question about the when to use clustered indexes section though. The sentence below...

I think I got it to work with a scalar function. Just running into a one-to-many relationship problem now, which I should be able to resolve. Thanks for...

Thanks Ninja! I think that did it. I was right, I was over thinking the problem and made it more complicated than it needed to be. I...

Thanks for the reply. Yeah, sorry if I wasn't clear enough. My biggest problem has been splitting the returns and sales and then doing the quantity counts and...