Damn, got beaten again .

Actually, I can answer for #2.

If there's an index on the table on a column that is not nullable, then the query will scan that index to count all rows.

If...

Glad we could help, can you post back when you find the solution so that others can benefit from your experience?

Am I the kind of fuy that intervenes??

Obviously.... When I wrote that I just remembered that you had 4+ billion values... forgot that half of them had to be negative...

Dude you gotta STOP USING DYNAMIC SQL for such simple task. I strongly urge you to read this before you get hit by a sql injection attack...

Makes me nervous here (inherited from on old system, I would definitly not design a system like that). I talked about that to my boss and we decided to...

maybe I'm missing something here, but unless you corellate the subquery, you will get the same value for the whole resultset... is that what you want?

might not be what you wanna hear, but you can save the dts, then call it from vb. Do you want to avoid the dts all together?

Hehe... you seem to have more experience than me under this topic.

Hence my few tries .

I'm no expert at this either... had to do a few test but this seems to work :

Under the events to profil (user the standard trace)

keep the Stored proc...

Does that mean that we can't rely on this information??

"Estimated rollback completion: 100%. Estimated time remaining: 0 seconds."

Yes... and it takes only one .

Maybe but in my case, I always preffer to learn more than less.

Hehe I see the confusion here. I was referring to the fact that the FINAL select will, on very rare occasion, return top 2 + tie like this >>

set...