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...

Thanks for your reply. However, the columns in question are not concatenated. They are separately selected columns, but with a certain set of joins, the values of the second and...

Thanks for your reply. An earlier person said that the output I got from select @@version does show that our SQL Server is on SP4. (Although perhaps the OS is...

I agree completely. I don't know of any other problems people have had with Amazon, but generally I've been satisifed with their service. I would not have expected them to...

Interesting. What is the legal basis for siding with the customer in that case? If a customer makes a mistake and, say, could somehow pay Amazon $20.00 for a book...

That may be the law. But what is legal and what is moral is not always the same thing. As a consumer, I would love to live under that law,...

I can see that that might matter for some people who rushed through the screens without seeing anything but the last one. Realistically speaking, though, I bet most of the...

I think the right thing to do is to honor the deal - buy one get one free. Not get two free.

Having said that, Amazon is lucky that in...

Thank you!

webrunner

I would like to post the whole script, but I'm not sure I'm allowed to, given it is a database for a product we've licensed from a vendor.

The script...

Great, thanks. I think I will use the method of using a stored procedures to bring the data over to the same server and re-create the view without using the...