Jack Corbett (8/5/2008)

---

I don't know, based on your time in the field from your recently posted article, I feel like I need to show you proper respect and call you...

Yes, and that seems like a reasonable...

timmy_patterson (8/5/2008)

---

I'm having trouble understanding Step 4. Where do tables 'TAB' and 'Tally' come from?

Thanks,

Tim

Insert into SOURCE(Name, Age, Sex)

Select Name

, Age

, CHAR(ASCII(Sex) & 1) --extract and preserve the [Sex]...

karthikeyan (8/5/2008)

---

Excellent article !:)

Actually you gave a variety of good & tasty food in a single box. If you write more articles like this , it would help very much...

Heh, "Mr. Young"?!? Heavens, I'm old but I'll never be that...

Antares686 (8/5/2008)

---

But my first impression was the first example for the contact numbers. I noticed you made 4 passes over the data instead of just the one. And even thou...

Your existing ODBC should still work with very few changes (interoperability was ODBC's goal). Have you tried it?

Jeff Moden (8/4/2008)

---

Jack Corbett (8/4/2008)

---

You can use sp_msforeachdb and set @command1 to "Select table_schema, table_name, column_name, data_type from infomation_schema.columns".

[font="Courier New"]sp_msforeachdb @command1 = 'Select table_schema, table_name, column_name, data_type from INFORMATION_SCHEMA.COLUMNS'[/font]

Here's an...

The SYSOBJECTS table is really a SQL2000 compatibility view and cannot represent everything in SQL2005 100% correctly. In particular, it cannot represent the SQL2005 separation of Schemas & Owners...

Right Bob, that was another option. However, I did not...

Jan Van der Eecken (8/5/2008)

---

Brilliant article! Reminds me somehow of one of my colleagues who wrote the following in C:

int x = 1;

int y = 2;

x ^= y ^= x...

JohnG (8/5/2008)

---

This was a great article and I really enjoyed reading it. I'm particularly grateful for the excellent explanatory text which meant I could actually follow most of what...

Pretty good, Phil. I think that that is almost the same as Chris Morris's.

Heh. Thanks, Samuel, that's one of my favorite. Some of the other fossils and I do...

Tao Klerks (8/5/2008)

---

Hmm, my curiousity is piqued... The solution presented is quite interesting, but I believe the purported interest in bits and bytes is a little exaggerated, as the solution...