You can, but you can't read the temp table after your initiating procedure regains control, the table has disappeared!

Do your own logging. Define a permanent table to log the date/time start and end of select statement in the stored procedure. You don't have to log after...

The output table is the result of a dynamic pivot, so the columns created depends on the values in the data. Yes, its non-deterministic, but fairly standard practise, is...

Thanks 🙂 , but I'm trying to run some dynamic sql which I have built into a memory variable, rather than calling a stored procedure. Something like:

select *

into #tab

from...

Excellent suggestion. Also,

insert into #tab

exec (@MyDynamicCode)

But "insert into" will only insert into an existing table. What about creating a new table?

This is 2013. Surely there is a way to reformat text to suit the width of the device displaying the text? Why settle for a particular fixed width...

Other possible "rough matching" filters to apply before the full matching routine:

- the first characters must match

- one of first two characters must match

- 2 out of the first three...

The paper you really need to read is:

A Guided Tour to Approximate String Matching

GONZALO NAVARRO

University of Chile

ACM Computing Surveys, Vol. 33, No. 1, March 2001.

It gives a concise statement of...

Its unclear if you are trying to match individual words (as in name matching) or entire phrases. The performance of any routine which has to match every row against...