Those look basically okay. Looks like they should do what you need.

If you want more data on the subject of logging, take a look at these two articles:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

E-mail, cell phone and VPN are the top ones I think of first.

E-mail alerts from servers are definitely part of what keeps me efficient.

Because that way each insert is at the end of the table, and the table doesn't have to be split in the middle repeatedly because of inserts. Table splits...

Nice enhancement there! Definitely going in my goodies library.

(Actually, before it came up in this thread, I hadn't ever seen this solution at all before. Had to figure...

It's running 87 times because it increases by 1 each time, and there are 87 characters in the string.

The batch solution is what I ended up doing with something like this several years ago. Worked quite well.

Yeah, the XML stuff definitely works best for strings of numbers. Add in text, and you run the risk of having to clean it up.

Can you add a Case statment to the Diff value? "When Diff <=2 and abs(len(Name1)-len(Name2)) <= 1 then 'Y'". Will that solve what you need?

It only took six to turn...

Look up "Common Table Expressions" (also called CTEs) in Books Online. It has a good example of how to use one to resolve hierarchies like this.

Try something like this:

declare @Bin varbinary(100);

select @Bin = 0x004E4E1B;

select cast(@Bin as int);

Does that help?

Well, your post is better organized and more eloquent than mine, so that's helpful.

You're welcome.

You're welcome.

Try this, see if it helps:

if object_id(N'tempdb..#T') is not null

drop table #T;

create table #T (

ID int identity primary key,

Col1 char(1) not null);

insert into #T (Col1)

select substring('abcdefghijklmnopqrstuvwxyz', number, 1)

from dbo.Numbers

where number...