Andras Belokosztolszki (10/31/2007)

---

Grant Fritchey (10/30/2007)

---

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

IIF is an MDX expression used to build cubes. It corresponds to the immediate if...

This works:

create table #t

(Col1 nvarchar(50))

GO

create table #s

(Col1 nvarchar(24)

,Col2 nvarchar(24)

)

GO

insert into #t (col1) values ('a')

insert into #t (col1) values ('b')

insert into #t (col1) values ('c')

insert into #t (col1) values ('d')

insert into...

No. Analysis Services is for cubes. Totally different application. You just need to do the stuff in the post above to identify the appropriate SPID and then use the command:

KILL...

Adding the other column will only help if it turns the index into a covering index. If you're doing SELECT *... I probably won't do anything.

Shy details, it sounds like you're talking about temporary tables.

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