and my part of the project got simpler sort of. they no longer want the output to a file. just send results to a temp table and issue a select...

thanks i will do some more investigating using PoSh. still working on my cursor to get all the database names and pass them thru to the query part

Really appreciate input...

ok that got it thank you. i was worried about aggregate errors i never tried that. So thank you very much.

Yes sir, got some other things to work thru but that was the hurdle.

you know how it goes when you inherit someone else's project that has left the company a...

Thank you so very much. I will definitely do some PARTITION BY learning.

Thanks...

i added that code and got closer but i also needed the applicationname to match the custapps.app column so i added it to the query. however i am only get...

Sorry i know this is probably childs play for some of you but i have a long ways to go.

Thanks for the help, it is done and moving on to...

the Identity column is not col1 thru col4, it is col12

I am just trying to insert from table1 to table2 (with a unique index) but i get duplicate errors when...

Sorry for late replies, but all this turns out to be a moot issue. I wrote the script for someone else and they were running it and told me that...

Yes I would like to avoid removing the index and then adding it back. I have already started setting up my code to do that but then thought there has...

that will work like i want.
thank you so very much .