Agreed on the wrapper proc.

Recompile can cause serious bottlenecks, not just because of the CPU time to do the compile.

While an object is being compiled, an exclusive lock is...

I'd suggest split into two. One for when the beginning of the name is specified (because it can use an index if there is one on name) and one for...

I'd recomend removing the recompile and rather split the stored proc into two, one that retrieves all candidates, one that retrieves a single one by name.

The problem is that depending...

Two databases, or two tables?

Can you provide the table's structure, some sample data and an example of what you want please

Your wild cards are a little too wild. Keywords LIKE '%c%' will match any of the following. 'Access','Visual Basic','C#', 'Javascript','Cobol',etc

That may be the cause of your 'ghosts'

The same way you'd use it outside a stored proc, or anywhere else for that matter

SET <variable> =  dbo.<functionname>(<parameter list> )

And please don't post multiple threads regarding the same problem

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=367811

Are the tables in Access or in SQL? * is the access wildcard. % is the sql equivalent.

p.s. using wildcards like you are will almost guarentee terrible performance with large...

That query should be fine, and there should be no need for locking hints.

Please can you post the enire trigger code and the schema of TableA?

There is one? That's news. Could you drop me a private message wit it please?

Or when the query includes a half-written stored proc. See the OP's latest posting.

Between works quite well.

Think about what it means for an ip address to be in a range.

60000 rows is small. Shouldn't have trouble changing the schema for that.

Otherwise, substrings and comparisons.

The commented out stored proc has the right idea with the substrings. You'll just have to...

Nolock has no effect in an update statement. It only affects read locks.

Could you post the trigger's code and, if possible the deadlock graph (obtained either using profiler, or from...

More homework?

(http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=366682)