Jeff Moden

Forum Replies Created

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

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
RE: Timestamp to Datetime

javid.alimohideen (4/6/2009)
True,
I completely agree with you that it is a bug. I was just looking for a quick workaround to keep the process going until I fix it with a...
--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 11:12 am

#973637
RE: Timestamp to Datetime

Heh... actually, I love it being there... I'm currently working as a consultant and gives me more to fix. 😀
--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 11:11 am

#973634
RE: The T-SQL Paradigm

wldhrs (4/6/2009)
Jeff Moden (4/6/2009)
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.
I disagree...
--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 11:09 am

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

Gift Peddie (4/7/2009)
Personally, I don't care if you're black, white, yellow, red, brown, purple, male, female, something in between, have 3 eyes, or glow in the dark... if you can...
--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 11:02 am

#973621

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