I probably should get a little more specific. Here's what's...

Sprabhakaran -- please understand that we're not trying to ridicule you, we just want to make sure that your question is answered.

I'm going to put on my technical writer's hat...

Ummm . . . NOBODY has time, much less, wants, to read a book!!!

I guarantee that everyone (myself included) is taking one look at your massive block of text...

That is a LOT of columns. No wonder why you're getting out of memory issues.

Is there ANY way you can break...

http://www.sqlservercentral.com/Forums/Topic854826-23-1.aspx

314 columns?!?!?!?!?!?!? One million records??????

And he's wondering why he's getting out of memory errors???

Kewl! Well done.

Argh . . . looks like your two tables are using different collations!

There probably...

Try this:SELECT AgentIP

FROM ConfigDB.dbo.NODES CDB

RIGHT OUTER JOIN MainDB.dbo.NODES MDB

ON

CDB.AgentIP = MDB.IP_ADDRESS

Note: I'm guessing on where to put CDB and MDB on AgentIP and IP_ADDRESS, because I have no idea...

Go to BOL and look up DATEADD.

I just looked it up myself. You're going to need to split the hours, minutes, and seconds to use DATEADD (this can be...

Found this: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64359

It means you haven't assigned aliases to your join objects. I didn't see any alias on your join that indicates what column belongs to what table.

Just curious: is anyone else besides me struck by the number of people asking about character-to-date conversions?

Just goes to show that IT really is the job from hell! 😀

Ray K (1/21/2010)

---

Your opinion: what are the best and worst places to watch a game?

My list might look something like this (all major league, unless noted -- also, I only...

I've been to the...

Lynn Pettis (1/26/2010)

---

Ray K (1/26/2010)

---

Our OP sent me a message to say my understanding of his problem is dead-on.

Alas, I don't have as much SQL experience as many of you...