Based on the description I still don't understand what the temporary view was doing for the query in question.

I got hired once because I'd been in the Navy... that's as close as I've got to an "outside" talent getting me hired story... Jeez, that sounds pathetic.

What would a "temporary" view do that a query doesn't?

You ought to go and read up on these topics in the Books Online(BOL) (the SQL Server documentation that gets installed with the product). Then, if you have specific questions...

Course not. I wasn't worried about that. But I was being lazy & you caught me on that.

Yeah but when you run two queries each shows a relative cost to the execution as a whole. Usually the speedier, lower cost, process shows as a smaller percentage of...

Can you show the execution plan for this query? Output it as XML and attach it to a post.

You may want to look at SSIS as a mechanism for moving...

That error could be a lot of things:

http://support.microsoft.com/kb/180843

http://support.microsoft.com/kb/304070

There are more. You'll need to investigate more on your end and send more information around the error to narrow it down.

The whole idea of using SQL Server as relational storage engine is to not store things in a comma seperated field. You're going to have problems with that. Instead it...

But to be utterly honest here, simply reeling off a few buzz words about what's new in SQL 2005 won't get you very far in an interview around most of...

You have to declare the data type when you create the procedure, so you should know what data type you're returning.

Or are you asking how to know what data types...

That is a bit odd. Usually there's a pretty direct correlation between cost & time. Also, looking at the two queries, I would expect the second query to have a...

While you fixed your problem, you still have another one lurking. You have an index on a column that has 30,000 identical values out of a 100,000 row table. That...

For some reason I thought it was Client Technology Preview, but Community makes more sense.

It was just one of the solutions he offered. It was only the second solution and it ran faster than his initial solution. He did spend a lot of time...