Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,296 through 44,310 (of 59,101 total)

RE: Are the posted questions getting worse?

Bob Hovious (4/7/2009)
... this is the kind of newbie I like to see...
He is a trophy. Stuff him and mount him on the wall. You could tell from...
--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 7, 2009 at 10:53 pm

#974009
RE: Compare Two Tables

AFIFM (4/7/2009)
Is this domain type??
No it is not. One of the legacy applications (A) uses 'Access_Level' as VARCHAR which only uses "1", "2", "3",....."8". The second application (B) uses the...
--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 7, 2009 at 10:45 pm

#974007
RE: Crosstab type report -- Horizontal Summray

Ok... here we go. I copied your very fine test data code and added the answer to it...
[font="Courier New"]--Post to SQL Server Central
--===== If the test table already exists,...
--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 7, 2009 at 9:19 pm

#973976
RE: Crosstab type report -- Horizontal Summray

Maxim Picard (3/27/2009)
You can find two excellent articles from Jeff Moden on cross tabs and pivots here that should help you tackle this challenge.
Cross Tabs and Pivots, Part 1...
--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 7, 2009 at 8:30 pm

#973971
RE: Crosstab type report -- Horizontal Summray

Joseph Henry (4/7/2009)
I'm posting code to create my tables...
Now we're cooking with gas! Well done, Joseph. Lemme see what I can do.
--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 7, 2009 at 8:29 pm

#973969
RE: Are the posted questions getting worse?

By the way... this is the kind of newbie I like to see...
http://www.sqlservercentral.com/Forums/Topic685148-338-1.aspx
The man's original post was absolutely typical of a newbie post. So were a couple of his...
--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 7, 2009 at 8:24 pm

#973967
RE: Are the posted questions getting worse?

Lynn Pettis (4/7/2009)
Jeff Moden (4/7/2009)
Actually, there are a dozen or so good folks on this forum that I'd like to see get the MVP.
I did a little more reading, Jeff....
--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 7, 2009 at 8:10 pm

#973964
RE: Just Walk Away - Blacklisting - and Twits without Twitter

GilaMonster (4/7/2009)
Jeff Moden (4/7/2009)
I sometimes have a similar problem with age... most young folks look at my white beard and chuckle about what Santa Clause might know about databases. ...
--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 7, 2009 at 8:03 pm

#973960
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Bob Hovious (4/7/2009)
... kindler/gentler... I learn something new every day here, even if it isn't about SQL.
BWAA-HAAA!!! Me too! I just looked those two "new" words...
--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 7, 2009 at 8:00 pm

#973959
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Steve Jones - Editor (4/7/2009)
GilaMonster (4/7/2009)
Similar thing here. In my country, woman and IT don't usually go in the same sentence. The number of times I've been 'mistaken' for the...
--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 7, 2009 at 7:56 pm

#973957
RE: The T-SQL Paradigm

Jason Miller (4/7/2009)
Jeff Moden (4/7/2009)
Other people love the darned things and that's fine for them... just don't want anyone forcing such rules on me.
I'm stepping out on a limb...
--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 7, 2009 at 7:41 pm

#973952
RE: The T-SQL Paradigm

David Walker (4/7/2009)
I won't begrudge you doing whatever you need with multi-page SQL statements (yech) but in your case, I would try a few common table expressions and see what...
--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 7, 2009 at 7:36 pm

#973949
RE: Idenity column question /issue

xgcmcbain (4/7/2009)
its for a business app reason, since my list is so large, and i have multiple apps hitting the same table, each of them grab a chunk...
--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 7, 2009 at 1:20 pm

#973742
RE: Best way to strip time from datetime stamp.

GSquared (4/7/2009)
Jeff, the problem with the convert(int) method is that it, again, relies on the internal storage of datetime, just like the version for float.
Have you tested it in SQL...
--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 7, 2009 at 1:16 pm

#973740
RE: Best way to strip time from datetime stamp.

I agree with Michael that the DateDiff/DateAdd method is probably the best for guaranteed future compatability.
Here's some code that I wrote a very long time ago (long before...
--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 7, 2009 at 12:21 pm

#973712

Viewing 15 posts - 44,296 through 44,310 (of 59,101 total)