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...

Ray K (1/26/2010)

---

Okay -- for anyone trying to work on this, I've put together a quick 'n dirty test scenario.

Here's the sample data:create table #test1 (tdate date)

go

create table #test2 (fdate...

Jack Corbett (1/26/2010)

---

Ray K (1/26/2010)

---

Lynn Pettis (1/26/2010)

---

Alvin Ramard (1/26/2010)

---

Alvin Ramard (1/26/2010)

---

Edit: Oops,...

Wow, three people posted samples simultaneously. That's gotta be some kind of record! 😀