Steve, Matt and Gregg - thanks for your kind...

Jeff Moden (1/3/2011)

---

I have to admit, I've not yet had to enter the realm of loading XML files. But now I know where to go for a quick reference....

shad-873858 (1/3/2011)

---

Yes, as the author noted, you have to provide an alias to the OpenRowset. In his example the author used rs. This will get you past that...

Paul - thanks. But...

Kelsey,

Good, I'm glad it all makes sense. If it hadn't, I would have failed.

SQL-DBA (1/3/2011)

---

I wonder what others are doing about doing an example like this when the XML is from a web service. I run into that more often then XML...

Kelsey Thornton (1/3/2011)

---

WayneS (1/1/2011)

---

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all,...

Excellent question, thanks!

The only thing that is missing is how to solve this type of problem - you need to split the items in the variable into their separate items,...

a.e.ghorbani (1/1/2011)

---

i have 2300 tables in my database.all of tables have relation together.i want to move tables to another filegroupe whitout remove my relation or without any change .only i...

piet.kouwer (12/31/2010)

---

Hi all,

perhaps this question had been asked before, but I don't exactly know which keywords to use on the search-engine:

Sometimes I read code (e.g. on the Internet) to insert...

olie480 (12/31/2010)

---

I don't know if this can be done or not, but is there a program, or anything I can do to import a CSV, and whatever quantities are in...

Here's one method that will get what you want. It may not be the best performing, but depending on the size of your data it may be acceptable.

-- See how...

Does this "Date_Stamp" column store just the date portion, or does it include the time also?

How big of a date range are you talking about?

Thanks for the DDL script and sample data - makes it worthwhile helping someone if they help us a wee bit first.

How does this work for you?

;

WITH CTE1 AS

(

-- Assign...

Adam Machanic (12/30/2010)

---

Glad to hear that it worked!

Why did it cause a problem? Well, the fact is that XML indexes in SQL Server are really not well integrated with the...