That answers my question. Thanks!

Yes I didn't make any sense...I had a confused moment! What can I say? It's Friday 😉 Thanks again for all of your help

Thank you so much for your reponse! I really appreciate you sharing your knowledge. It works for exactly what I need.

I'm thinking of future needs now...If I ever wanted...

So since the Database Services, Analysis Services are cluster aware, there's not even a need for a failover?

Thank you for your response!

Should I choose a different folder for the components install rather than the default?

Yes the vendor was very adamant about keeping the versions separate. So would I install 2008 and then an instance of 2005?

It worked...thanks so much!

Oh I see...it's for a single quote. Clever, thanks again.

Thank you so much...this worked!

What is the CHAR(39) for?

Our OS and SQL server is 32 bit though

Thank you, David! I was thinking the same thing.

Upon closer inspection, that query didn't work. I'm thinking that this is a dead end since the same columns have to be in the query 🙁

that worked...thanks so much!!!

Thanks for the reply. I tried this, but I can't get it to do exactly what I want

I want the result to show addtl fields to the PtID and the...