This would be handy for a DBA if all the servers are in the domain, but rather than make a batch file with a list of all your servers by...

Eh? The argument seems to be that if you restrict the number of emails in the list to 5, then the problem is...

[font="Courier New"]UPDATE  #tempa

SET  alternateemail=emails.AlternateEmails

FROM  #tempa

  INNER JOIN (SELECT

                customer_full_name, postcode,

                SUBSTRING(COALESCE((SELECT ','+customer_email

                                    FROM

                                      #tempb b

                                    WHERE

                                      a.customer_full_name=b.customer_full_name

                                      AND a.postcode=b.postcode

                                    FOR XML PATH('')

                                   ), ','), 2, 8000) AS alternateEmails

              FROM

                #tempa a

             ) emails

    ON #tempa.customer_full_name=emails.customer_full_name

       AND #tempa.postcode=emails.postcode[/font]

for me, it is 'the mighty claw of vengeance'. Perfect.

Yes. I was wondering if the complexity of getting started with it, and the ridiculously bad training materials, was the reason. The product seems very solid and efficient. Adam...

Did you not have a smart device - and type the SQL then electronically send it to the guy so he could just cut and paste the code into place?...

Hugo, I heartily agree with the sentiment, but I hate to actually recommend having...

Very sympathetic with Dan Humphries' experiences. It always surprises me that an industry that tries to appear informal and radical can occasionally become bureaucratic to the point of satire. I've...

This is a difficult problem to...

I must say I enjoy your editorials. I agree that one can always do more, but whatever it is has got to be sustainable.

Despite the indications to the contrary on...

I agree. I find the object browser puzzling in the...

Right on the nail. If you can crack the...

I really enjoy seeing scripts like this, since the whole topic of scripting is fascinating. What I really like about this is that someone has gone ahead and brewed a...

John, this is a fascinating thought. As I read it, it would be no defense for the director of a company guilty of a breach of the DP Act that...

[p]Oh dear. This article really should have explained more. As it stands, I'm afraid it is rather misleading. Although it is right in saying that many such procedures will...