Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,341 through 44,355 (of 59,101 total)

RE: Compare Two Tables

AFIFM (4/6/2009)
I need help with the SQL query to comare two tables in two seperate databases on the same server. The tables have FirstName, LatName and Email as common fields.
I...
--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)

April 6, 2009 at 11:11 pm

#973096
RE: varchar to date derived tables

Op accidently posted in wrong forum. This thread answered in the following post...
http://www.sqlservercentral.com/Forums/Topic691647-169-1.aspx
--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)

April 6, 2009 at 11:06 pm

#973095
RE: varchar to date distinct select

This will likely be slow one way or the other, so you may want to turn it into a function. This seems to catch most
of the aberrations you've...
--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)

April 6, 2009 at 10:57 pm

#973090
RE: How to return a "start of group" column?

Soooo.... does that mean you're happy now?
--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)

April 6, 2009 at 9:52 pm

#973061
RE: The T-SQL Paradigm

Steve Jones - Editor (4/6/2009)
Jeff Moden (4/6/2009)
Heh... no, I get it. But there are still rules of thumb that absolutely must be followed.
There are, but unfortunately we...
--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)

April 6, 2009 at 9:49 pm

#973058
RE: The T-SQL Paradigm

Heh... brackets... they sure did take a shortcut there. It would be nice if the automatic code generators didn't put those in unless actually required.
--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)

April 6, 2009 at 9:47 pm

#973057
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/6/2009)
Jeff,
We have two developments ongoing. One was our regular developer/week a month that I believe tried to fix some code items. Those are in test now,...
--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)

April 6, 2009 at 9:28 pm

#973053
RE: Challenging SQL interview questions

On the Halloween thingy... that's what I call an "oolie" and it shouldn't make or break an interview. If someone knows it, then it may be a bonus unless...
--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)

April 6, 2009 at 7:05 pm

#973025
RE: Challenging SQL interview questions

Paul White (4/5/2009)
Also try to remember what it was like when you first started out.
Actually, that's a pretty good point. So is the point about newbies not knowing some...
--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)

April 6, 2009 at 7:00 pm

#973021
RE: Challenging SQL interview questions

Paul White (4/6/2009)
@jeff,
Thanks! But all those smileys have left me emotionally confused :-DPaul
BWAA-HAAA!!! Now that's funny! Like I said, "Welcome aboard"... you're gonna fit in just fine.
--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)

April 6, 2009 at 6:46 pm

#973016
RE: T-Sql rant

cs_troyk (4/6/2009)
Not to mention, Jeff, that you missed your mark by one post. Or is it OK for Sergiy to call Steve's post (or was it Steve?) "a pile of...
--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)

April 6, 2009 at 4:57 pm

#972990
RE: Challenging SQL interview questions

GSquared (4/6/2009)
Jeff Moden (4/6/2009)
Here's a perfect example...
http://www.sqlservercentral.com/Forums/Topic688949-8-1.aspx
My answer would have been... "Thanks for the setup code... please post the code that you've tried so far so we can point you...
--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)

April 6, 2009 at 10:42 am

#972722
RE: The T-SQL Paradigm

davidandrews13 (4/6/2009)
i code in VB.net and i'm relatively new to using SQL, only doing it for about 1 and a half years, so i have to admit that i dont...
--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)

April 6, 2009 at 10:16 am

#972691
RE: Challenging SQL interview questions

Here's a perfect example...
http://www.sqlservercentral.com/Forums/Topic688949-8-1.aspx
My answer would have been... "Thanks for the setup code... please post the code that you've tried so far so we can point you in the right...
--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)

April 6, 2009 at 8:57 am

#972590
RE: Challenging SQL interview questions

I agree... Barry's initial response was a bit "curt"... and I also think it was absolutely appropriate.
Look at the list of items asked in the Original post... these are relatively...
--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)

April 6, 2009 at 8:50 am

#972585

Viewing 15 posts - 44,341 through 44,355 (of 59,101 total)