so if i read you right then something like this would work i think assuming c2 in source would equal c2 in tablex

INSERT INTO destination(c1,c2,c3)
SELECT...

Ah good spot on the ends with results query, didnt notice my mess up there. at least it wasnt an issue with the query that does the search just the...

Thanks for your comments, this is not a production script, nor is it designed for anything other than internal use.  It only supports text, date and number searches so i...

Nice, I dont get a lot of data in xml columns so never actually added that. I will warn you however that switching the like with no percents to...

Yeah i actually have the same thing over here, just that its generally slower than the one i posted. This script does give you the counts still just that...

yup not a problem at all here you go. now the tblqry column has the "select count(1)", the sqltxt will now have "select *" errors now are...

Yeah haven't had that one come up but i imagine its possible, usually the errors are for calculated columns or improper search terms, ie searching for a date that is...

Yeah originally they were slightly different. tblqry was the SQL for the counts, and sqltxt was the same query but with the column selected instead of the count. basically...

Yeah it can be a memory consumer for sure depending on the search and the size of the database and the amount of data it contains. I have read...