Nah, neither method is "wrong". If you're opening the XML from a file, definiately do what Andras suggested. If you're receiving the XML from an application through a parameter, I'd...

I think they want the loan guarantees because, quite frankly, the next administration (regardless of individual or party, not picking a fight with anyone), can reverse the directions & decisions...

I'm not entirely sure on this, but I believe that the statistics maintained don't include NULL values.

If I recall correctly, statistics are based on 200 rows from within the...

Use the suggestion above, or if you're passing the XML in as a parameter use the OPENXML syntax

DECLARE @Handle int

EXEC sp_xml_preparedocument @Handle OUTPUT, @XmlParameter

INSERT INTO TABLE x

SELECT ...

FROM OPENXML (@DocHandle,...

Lowell (10/29/2007)

---

i thought float,real and numeric were non-deterministic so you get approximations like 3.99999999999999999994 for the value of 4.00 stored and such...., and it was better to use money or...

happyme_01_cool (10/30/2007)

---

I just thought id try it out, n i came up with

SELECT dbo.course.cname, dbo.enroll.classno

FROM dbo.course INNER JOIN

...

Nice job Gail.

Talk to you later Sandy.

That's a really interesting wind power generator. The cost does look interesting. We're already off the grid for heating the house (outdoor wood burning furnace), water and waste disposal, so...

Michael Fried (10/29/2007)

---

That was one of my initial thoughts as well but I think there are a number of issues that prevent using a file:

* Concurrency Problems - there will...

Save it to disk with the extension .sqlplan. You can then reopen it as a graphical execution plan.

2005 has a more granular time field internally. It deals in micro seconds instead of milli seconds. That might explain it. It still stores datetime fields as milliseconds. I had...

It's just a series of joins & where clauses. If you've paid any attention in the course, you should be able to do this stuff. If you get stuck on...

Oh that's all right. You have one too. 😀

Sandy (10/29/2007)

---

Hey Grant,

Can you have a look on to my last post..

I will be happy if you and jeff will have a

sharp eye on my post.

Thanks a lot for...

Honestly, one table... Why put it into a relational data management system? Assuming at least a good primary key, this can be accessed faster from a file than from the...