ae299 (4/10/2008)

---

But how do you copy data from TABLE to TABLE on a remote server

as mentioned in the original post?

BULK INSERT / BCP seem to load OS files only,...

helloanam (4/9/2008)

---

The one way I've found to get around this is to first move the data into a table variable, then move it to the other server. Since table...

John (4/9/2008)

---

Team...

I am actually confused over the terms SQL-Server, SQLExpress, MASTER, default, server and instance.

I am having trouble getting MS-Access table-data exported / upsizing to an existing SQL-server/Express MDF database.

I...

In my experience, procs that move data from one server to another tend to be slow. It's the overhead for managing large transactions across the network.

I've generally had much...

Have you looked at Pivot and Unpivot for this?

You might give RedGate's Prompt a try. Or ApexSQL Edit. They're both built for coding SQL.

Anything more powerful than Notepad will almost certainly cost some system resources, but...

Then I think you're stuck with the query as-is (with the cast to varchar(max), of course).

With the table structure, some sample data, etc., it might be possible to improve on...

I may be missing something here. I don't see any aggregate functions in this query. No Sum, Count, Max, Min, Avg, etc. Without those, are you just...

If these are interview questions for you trying to get a job, I'd have to say the answer is, "I don't know, but I can look it up." If...

Do you have multiple rows with the same ntext data?

Also, if you can, please include a copy of the text of your query.

A derived column might be the way to go on that. If you look up Cast in books online, in the Integration Services section, it will give you the...

There is a cast type function in SSIS. Are you already using that?

Yeah, Stuff has yet a third layout inconsistent with either Replace or Charindex. There's a reason I have the string functions page bookmarked in BOL.

There isn't any performance difference.

There are two better options than your @timeid, though that one is a good step in the right direction.

One option is to use the SPID as part of the primary...