You took the words right out of my mouth. I understand that someone might naively think that password uniqueness is some kind of extra security. But telling someone that they...

Hello,

Sorry to take so long to respond, but I wanted to thank you for this code. It worked exactly as needed! I am still a little amazed at the syntax...

Thanks for all of the in-depth comments!

Due to time, I decided not to work on the query side as suggested above. Instead, I decided to put the values in the...

Sorry, I was unclear in my terms. I meant "temporary" table (not "intermediate" as in linking table for many-to-many relationship).

Thanks to everyone for the suggestions -- I'll test them out.

Another...

Honestly, I never used FoxPro, but I was nevertheless a little sad to see the news that it's being retired. However, if it will live on as a quasi-open-source project,...

Maybe it is this page?

Critical Update for SQL Server 2005 Service Pack 2 (KB:933508)

http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en

-webrunner

Thanks for the additional information. Do you have a page or a link for SP2a (or is it called the SP2 hotfix - or both)?

Thanks again,

webrunner

Hello Paul,

Yes, please post more details on using the Jet 4.0 text driver for this type of query. Others have also mentioned Reporting Services and also trying to determine if...

Thanks to everyone for their replies. I'm responding to Dan in particular since he asked a couple of questions. Regarding those questions, I don't have answers yet because the database...

I'm late to the party, but here is a quick comment.

I don't visit slashdot often, but when I do, there are usually some really interesting user comments posted. But I...

Yes, it may be more fuel indeed. I'm sure there will be XQuery advocates, just as there are of all technologies. But the core SQL paradigm has been so successful...

Yes, that's a good point. I'm no XML expert but what you quoted makes sense to me. Plus the couple of times I have used XML, it has been a...

I agree with you, Steve. I think it is great to have XML handlers that can easily translate from a table to XML and vice versa. After all, the point...

Thanks again for your help on this! I'll read up on the info you've posted.

Also, just to set the record straight, I think it was Jeff Moden who mentioned the...

Thanks for the clarification. I will read more about the OUTER JOIN in BOL. But I see the issue even without an OUTER JOIN, as shown below.

This is a version...