sp_QuickieStore: Mixing @query_text_search and @query_text_search_not created primary key violations in #query_text_search about darlingdata

[ReeceGoding]

My general impression from reading the code is that the two parameters simply aren't compatible. They both share the same column of the #query_text_search temp table. I have never made any study of this stored procedure, but it seems obvious that the two parameters won't work together if the list of included queries and the list of excluded queries have both been placed in the same column of the same table.

Perhaps we need to make a #query_text_search_not temp table and EXCEPT-out everything that it shares with the #query_text_search temp table?

[erikdarlingdata]

@ReeceGoding yeah, this just needs another temp table for the not search. I’ll fix it.