As far as I can see then, you're stuck with one of four options:

like

charindex

patindex

replace

The following shows each and some test results. From the looks of it, there isn't much difference...

Not a silly question Dwain. The ordering was supposed to be by Score, not Person. Which would make more sense.

Goodness me, so they are. Oh. *cough*

:blush:

Have you thought about using a full text index? It might be helpful in identifying records with links. You'd need to be careful with which stemming characters you use to...

Interesting this. Intuitively, my head says that pre-calculating the max value should be more efficient when compared with using a correlated subquery:

declare @MaxId int

select @MaxId = max(col4) from #TableB

insert #TableB...

You could expand the hierarchy (i.e. create a direct relationship between each node and all of its parents) and then run your queries against the expanded hierarchy.

This example does...

Hi all,

Sorry for the delayed response. Comments as follows:

pietlinden

Soundex doesn't really do the job here. As an example:

select soundex ('Dave') = D100

select soundex ('David') = D130

happycat59

Fuzzy lookup doesn't provide me...

Try sqlcmd

http://msdn.microsoft.com/en-us/library/ms162773.aspx

I figured updating this might help someone sometime.

Creating the replication agent job manually didn't work. The job itself could be executed, but it didn't do anything and didn't result...

Well that's a different case, clearly. If you do this, you'll have to set up replication on the restored database. Then I'd probably just drop and recreate the subscriber tables...

Assuming that your backup will contain the most recent data for the tables, then you shouldn't need to do anything. If the data in the restore is different to the...

Hi abhij33t,

It isn't really clear what you are intending to do. Are you dropping and recreating the database?

Regards, Iain

I operate much better at HW level 🙂

I guess I should have glanced at the visit stats before throwing around my egregious accusations ;-D

Think of a cte as another type of table variable or temp table, that instead of lasting for the duration of the session just lasts for one query. They're useful...

<hit the post button in error>