Peso (4/8/2009)

---

Chris, with the logic of the other Chris, how should this sample data be sorted?

1 7 9

NULL 6 ...

I believe it's 23.5%. 🙂

And definitely not fair, but within the rules.

Yeah, my data follows the rules, but plays havoc with any simple distribution assumptions.

😀

Fair warning: this is some truly wicked data. Pretty close to worst case.

One problem is that you guys are testing against Easy data. Now why don't you try some HARD data:

CREATE TABLE SortedColumnsTestData

(

id INT NOT NULL PRIMARY KEY CLUSTERED,

...

Jochen Vleming (4/8/2009)

---

I totally agree...

I believe that this happens in SQL 2000 because the compile "reads-ahead" or anticipates the datatype expected by the table column and then back applies it to the source expressions....

Probably either of these:

SELECT CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).value('(//*:CompanyCode)[1]', 'NVarchar(50)')

, CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).query('(//*:CompanyCode/text())')

from DocumentSource

You know what you do when you Presume? You make a Pres out of U and Me.

No, wait. That's not right ...

I think his real name is Foxy Jazz.

😀

This isn't valid XML. For one thing, the "NS8" prefix is never declared.

That's from WROX. And I suggest that you get the 2008 version instead of the 2005 book.

You can either use {DB_Name}.INFORMATION_SCHEMA.TABLES or create a view like this:

CREATE View vwAllTables as

Select 'DBOne' as [DatabaseName], * From [DatabaseOne].sys.Tables

UNION ALL Select 'DBTwo' as...

If you make your packages location-unaware, you can just Xopy them wherever you want.

dave b (4/7/2009)

---

Lowell, Thanks for the reply.

Let me clarify what I'm trying to do. I have a column that has a Timestamp (epoch unix timestamp) datatype. I need to create...