Yikes!

That code should be following the same pattern as the positive numbers did, not to 1.

It is a mistake.

Blown away by the use of charindex()!

I will try them all out.

Thank...

Thanks for the injection of clarity...you are quite right, i was bemoaning the lack of troubleshooting insight in the product. It does do monitoring, but I was disappointed because I...

Brilliant Holmes!

I will look into some other treatment for strings starting with numbers, but patindex with numeric wildcards was the correct approach, not charindex.

Thanks very much for your help

drew

Holy good night!

it definitely has the potential to cause one to question their sanity...that's some freakin' feature!

Thanks a ton for the heads up

Got it

Thank you

Yes, thanks.

I understand each 100K is a new all or nothing batch, and that there would be ten of them instead of one big one.

Thanks again

i found a good answer the first part of my question, but still in the dark about the VM part though.

http://www.databasejournal.com/features/mssql/article.php/3914366/Collecting-Performance-Metrics-Using-SQL-Server-DMV.htm

Hot Dawg!

even better

thanks very much

drew

obviously, didnt know that:cool:

thanks a ton!

Funny you should say that...I used to be part of a cube culture, but due to familial circumstances, my employer allowed me to continue working out of state as a...

omg i feel like such a dunce...

I apologize for bringing such a kluncker to the list and thank you profusely for catching it for me.

Holy Good Night!

I never would have thought of that, and it is breathtaking!

Thanks so much for telling me about it, I really appreciate it.

drew

Hi

my instinct is Access would be best, but iirc, you can create parametrized stored procedures in SSMS & invoke them from Excel...i guess it depends on how robust the front...

thanks very much...the execution plan is what informed me about where the query was so costly, but i was surprised to find that all the alternatives boiled down to 96%...

that was the missing ingredient!

thank you so much.

Why do i hear Steve Miller singing Abracadabra in the background?:hehe: