Viewing 15 posts - 8,581 through 8,595 (of 9,725 total)
Okay, this code is officially going to be my new best friend. @=)
Thanks, Ggraber! Cookies for you!
November 12, 2008 at 6:34 am
Aha. Didn't realize it was a paren. Thanks, Jeff. @=)
November 12, 2008 at 6:33 am
You're welcome. @=)
Glad we could help you figure it out.
November 12, 2008 at 6:11 am
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,...
November 12, 2008 at 4:14 am
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...
November 12, 2008 at 4:12 am
Jeff Moden
Ggraber has the right idea
Possibly, but his code is interupted by the forum turning part of it into a smiley face, which means I get a syntax error...
November 12, 2008 at 4:08 am
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...
November 12, 2008 at 3:56 am
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.
November 11, 2008 at 11:40 am
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...
November 11, 2008 at 11:37 am
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...
November 11, 2008 at 11:30 am
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,...
November 11, 2008 at 11:28 am
What about the rest of the table structure?
November 11, 2008 at 11:23 am
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...
November 11, 2008 at 11:15 am
Viewing 15 posts - 8,581 through 8,595 (of 9,725 total)