Mickey your link to Jeff's article is actually pointing back to this post. I think you meant to post to this article[/url]

I'm not sure what 60% means to you but you have a couple of possibilities:

1. If this is on-going then look into DQS: http://technet.microsoft.com/en-us/library/ff877917.aspx

2. You could try using SOUNDEX http://msdn.microsoft.com/en-us/library/aa259235%28SQL.80%29.aspx

...

I'm not the greatest at string manipulation, but here you go:

select substring(col1,CHARINDEX('Status="',Col1,1)+8, (charindex('"',col1,CHARINDEX('Status="',Col1,1)+8))-(CHARINDEX('Status="',Col1,1)+8))

I'm not sure you are asking the right question. I don't believe you need to drop tables or loop through the data. It seems like you would be able to...

Is this a one-time thing or an on-going process that you need to develop? Is the issue always as simple as Drive - dr., Lane - ln., etc.? Or is...

I couldn't find any documentation either, but they need to understand how a stored procedures and queries work. When you execute a stored procedure a lot of stuff happens, but...

So, if I understand your request you want to return all rows from db1 where the CASEID is not in the derived table? If that is true you can simple...

Do you belong to a local user group? If not, try finding a local PASS chapter: http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

Networking will be huge while you are looking to break in. Sign up to...

Hi Jeff - Welcome to the forum!

For these kind of questions please supply the following:

1. Scripts to create all tables that are required

2. Script to insert sample data

3. Expected...

Adi Cohn-120898 (10/22/2013)

---

You have to be logged in to the server that you want to query. Another option is to use login to 1 server and use linked servers...

As was stated above it doesn't have an effect on READ COMMITTED or READ UNCOMMITED, but it has a big effect if your isolation level is set to REPEATABLE READ...

You could run a query like this:

SELECT dbo.SQLAGENT_SUSER_SNAME(owner_sid)

, SUSER_SNAME(owner_sid) as OwnerName

, name as JobName

FROM ...

Like Kurt said is this a one off or a on-going thing. If it is a one-off and you don't want to use a tool to split the encrypted backup...

You may have leading and/or trailing tabs instead of spaces which the trim's won't replace. You can use CHARINDEX to find CHAR(9) in a string and then use the replace...

LTRIM and RTRIM only remove leading and trailing white space. It doesn't remove zeros. If this is a name field are zeros allowed at all? If not, then try REPLACE()...