Matbe you have a null in Surname which resets the string, and occurs near the start without an order by, but just before the end when you order it. You can...

sorry that it's v9 only. It's only because of the performance enhancements used, which could be removed.

/***find pairs of numbers equal bar one transposition of adjacent digits**/

Right I think I have it. I was hoping not to use any string functions, but I did in the end rather than using log10() a hundred times. I've used...

I know you're using 8, but as a related point, v9 has an XML data type. No doubt I will be corrected if not, but I think HTML can be...

I know you're using 8, but as a related point, v9 has an XML data type. No doubt I will be corrected if not, but I think HTML can be...

Yes, I found that mod 9 rule empirically using excel. there had to be something useful about the similarity and 'reverseness' of the numbers.

That is definitely the way to go.  I...

I think that your problem might be that @phq9_order_date is null.

It is populated by:

    select @phq9_order_date = max(done_date)

    from ah_member_order (nolock)

    Where account = @account

    and company = @company

    and seq =...

Here's the text:

"I would like a query that pulls back pairs of numbers that should be the

same, but one was mistyped.

Specifically, I am looking for numbers where two neighboring...

If a site can have more than one school, you either don't have enough info to join your tables properly, or haven't specified some rules that apply to the data.

If,...

tbl t

select

The code I've given should find the last occurrence of a space followed by a number, and remove it. Looking at the code again, it's wrong. Try:.

select

...

Go on, you're nearly there. Looks like you don't need the school table if you know the sitecodes. So join the other three, so that the calander date is within...

Glad to be of help.

Re trigger phobia: If the db list is only updated by stored procs, you could put the code in there. I know what you mean about...

You can 'read' it in any direction, but you will often want to look at the 'leaf-level' nodes on the diagram - for example you might be looking to replace...