XML is a binary data type so it has to de-serialized into a string before it can be cast to a numeric type.

Works because SQL Server XML data types...

ACE works with Access too. Here is the redist pkg you want to install:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en

The method using NEWID works well.

TABLESAMPLE is pretty handy too:

http://technet.microsoft.com/en-us/library/ms189108.aspx

john 50727 (5/27/2011)

---

Can you modify the table? Where I work, I have complete control of the database. I would separate the key out to three different fields and use a...

Yes, there is:

Build a module/screen/class/whatever-its-called-in-the-middle-tier-or-front-end-language of your maintenance application that applies to each reference table to allow users...

You're welcome 😀

tshad (5/26/2011)

---

What I am trying to do is try to return the values in certain reference tables. I don't know what the name of the tables are - this...

tshad (5/26/2011)

---

I am trying to write a stored procedure that joins a table or does unions that has the table name in another table:

ie, CREATE TABLE tables

(

...

Sorry, but this is an irresponsible comment and...

Good news, you can!

Have a look at SQL Agent Tokens:

http://msdn.microsoft.com/en-us/library/ms175575.aspx

I don't remember if name is available straight away, but job ID is and you can look up the name in...

Sounds like a resource contention issue...those are fun to figure out 🙂

>Are there network congestion issues in your environment?

>What else is running on the app server at the time...

Your question is very general for a forum setting...Google/Bing for "ssis tutorial" and "import text file" and start experimenting. If you get stuck on a technical detail trying to get...

It all depends on how you are built to learn...do you learn better by reading text independently? do you learn by doing? do you learn best via dialogue with a...

In your "after insert" trigger on Table A a MERGE statement could be used to update data in Table A from data in Table B.

MERGE BOL article: http://technet.microsoft.com/en-us/library/bb510625.aspx

Judy Scheinuk (5/26/2011)

---

I can't wait to try this. I have to wait until the job which is running now gets to a good stopping place which may be a...