You're welcome. @=)

Glad we could help you figure it out.

NP. Glad I could help. @=)

There is no such word as "impossible". @=)

Okay, forget about the INSERT part of the statement for the moment. Run just the SELECT statement by itself. What do you get?

Also,...

It's not always a Kerberos issue, SQLBOT. I've actually encountered this issue on other occasions.

But SQLBOT brings up a good point. Have you actually verified that your SQL Services are...

Possibly, but his code is interupted by the forum turning part of it into a smiley face, which means I get a syntax error...

I don't think you need a cursor & while statement either, but as others have said, we need the table structure before we can accurately help you. Don't assume the...

What is notifying you of this? Is this an error message when you try to detach the database?

If so, please list the full text of the error message.

This may or may not work for you. NOTE carefully the ON part of each JOIN statement

Select Table1.ID, Table1.FirstName, Table1.LastName, Table2.Answer, Table4.Title, Table5.PageHTML, Table6.Location

From Table1

Left Join Table2

On Table1.ID=Table2.AgentID

and Table2.Answer...

Sounds like either an ownership chain issue or your Linked Server is set up wrong between the two.

EDIT: Sorry. To clarify, check your Linked Server to make sure it has...

I have used this before when trying to insert records in a specified order and wanting the Clustered PK Identity field to sort accordingly:

Insert into MyTable (col1, Col2, col3)

(Select Col1,...

What about the rest of the table structure?

Gaby, what exactly are you trying to do with the resulting end data?

The way you have it listed, Michael is correct about string aggregation. You could also check into the...

What's the table structure like? Is there a column that specifically distinguishes between the header record & detail records?

Stephen Fletche (10/7/2008)

The question I actually came with in the first place.. ..what's the cheapest way of doing the qualification? I don't mind blowing a couple of hundred quid...

Do you have anyone who knows T-SQL in your organization? If so, you should go to them and ask them the best way to debug a stored procedure or a...