Sorry this took so long...

I have a testbed setup and can see the XML value from your DB query within a script task...it looks OK and as you mentioned now...

I thought of an option...I haven't done a proof-of-concept on it because I don't have a copy of Visual Studio here that supports SQL Server Database Projects but I did...

DECLARE @x XML = N'<parent><child>Hello World!</child></parent>' ;

SELECT @x.query('/parent/child') ;

Is this for a local instance of SQL Server?

pwalter83 (3/9/2011)

---

Now this is really frustrating. Without even reading the question, you have given a template answer. This way...

First issue: I think the reason why you cannot access the DB from Excel using Windows Auth while your machine is unplugged from the network is because SQL Server cannot...

TK-487581 (3/8/2011)

---

Yes, i've even tried the top 100 percent, but still no good.

So, just confirming - Index is only for performance. It has no hand in sorting the data, right?...

TK-487581 (3/8/2011)

---

Yes, i've even tried the top 100 percent, but still no good.

So, just confirming - Index is only for performance. It has no hand in sorting the data, right?...

The only way to guarantee sort order is to issue an ORDER BY in your query...this is a fundamental concept of set theory.

This may look familiar: The ORDER BY...

This may clear things up:

SELECT CONVERT(DECIMAL(6), 10.95) AS a,

CONVERT(DECIMAL(6, 2), 10.95) AS b

SELECT *

FROM sys.databases

WHERE state_desc != 'ONLINE'

You'll want to convert the numerator and denominator to float or some form of a decimal before doing your division...sorry I did not consider it.

Try this:

WITH cte(numerator, denominator)

AS (SELECT (SELECT COUNT(DISTINCT encounter) AS numerator

...

SQL Server will implicitly convert your data in the text file to the destination data type per the table definition. That said, if you exported some data from Sybase and...

You're very welcome :Whistling: