T-Sql Script question to compare values between 2 tables

Question

T-Sql Script question to compare values between 2 tables

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 1

Crud... I was just reaching for the bucket o' fresh pork chops... 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 2

Jeff Moden (1/6/2009)
Crud... I was just reaching for the bucket o' fresh pork chops... 😛

Fresh? You want to use fresh chops? Come on - you need to age them for a few days at least, just to make sure they have the right impact on the recipient. :w00t:

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

foxjazzG SSCrazy Points: 2221 More actions · Answer 3

foxjazzG

SSCrazy

Points: 2221

January 6, 2009 at 4:15 pm

#922249

don't you guys have jobs?

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

Jeff Moden (1/6/2009)
Crud... I was just reaching for the bucket o' fresh pork chops... 😛

ha ha, i was wondering if this post would catch your eye Jeff.

foxjazz (1/6/2009)
don't you guys have jobs?

job, wassat den??

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 5

foxjazz (1/6/2009)
don't you guys have jobs?

Oh hell yes! I'm a professional pork chop launcher! 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

GSquared SSC Guru Points: 260824 More actions · Answer 6

foxjazz (1/6/2009)
don't you guys have jobs?

Yes, I've been hired by a shadowy international group of conspirators. My job is to annoy people who suggest using cursors in SQL Server. The pay is pretty incredible: $100/hour. If only it weren't Zimbabwe dollars... oh well. Fortunately, I also moonlight as a DBA.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon