Could you post the query?

Thanks stax68 and others!

That was a much more complete answer then I had gotten at the other site.

I didn't go through the links but another advantage of the table variable is there is no logging so you don't have that overhead.

At this point I'd need to get a DBA involved.  I'm just a lowly apps programmer.

Try running this first in the desired database from Query Analyzer:

sp_sdidebug 'legacy_on'

Run in the desired data base from Query Analyzer:

declare @s varchar(255)

set @s-2 = 'Text to Search Here'

DECLARE @msg varchar(255) ,

  @ul varchar(255)

select @s-2='%' + @s-2 +...

This isn't really what you asked for but it searchs for text and I use it to look for tables in SPs:

declare @s varchar(255)

set @s-2 = 'Text to...

Math is one of my weaknesses and some of you seem good at it.  This is a routine I inherited and use in production.  It is to round from four...

Have you looked into CHARINDEX and PATINDEX in BOL?  I think that's what you are looking for.

You can also run the queries from inside Excel, I'm using 97.0. You have to play around a little but once you get it going it's easy. To...

Thank you!

There's been times I've wanted to insert the results from a stored procedure into a temporary table also. I don't think there is a way. Maybe someone does????

I view a couple of different sites each morning. Your question looked similar to this one. I didn't look very closly but maybe it is worh checking out:

Sorry...I didn't test the cursor loop. Just did it freehand:

Declare @pkClaim int

DECLARE MyCursor CURSOR FOR SELECT pkClaim FROM Claims

Open MyCursor

FETCH NEXT FROM MyCursor INTO @pkClaim

WHILE (@@FETCH_STATUS -1)

BEGIN

...

Looping is not a good idea but sometime, paticularly for one time deals, is needed. Here are two basic loops:

Cursor:

DECLARE MyCursor CURSOR FOR

OPEN MyCursor

FETCH NEXT FROM MyCursor INTO @pkClaim...