Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,411 through 46,425 (of 59,101 total)

RE: The Set-Based Limit

Oh yeah... almost forgot... you need a Tally table for that code to work... please see the following...
[font="Arial Black"]
The "Numbers" or "Tally" Table: What it is...
--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)

December 25, 2008 at 11:57 am

#917659
RE: The Set-Based Limit

Kit Brandner (12/22/2008)
Try a 23-character long alphanumeric PIN code with certain characters excluded for legibility that can't be repeated in the database. So Jeff's solution wouldn't work. I suppose 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)

December 25, 2008 at 11:52 am

#917658
RE: Are the posted questions getting worse?

Heh... there's an Auto Industry in Michigan??? 😉
--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)

December 25, 2008 at 9:50 am

#917648
RE: Aggregate bit operator in TSQL

I find both those things to be true with a lot of authors.
--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)

December 25, 2008 at 9:47 am

#917647
RE: Get Missing Data with Tally Table

You're supposed to ask for them BEFORE Christmas! 😛
--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)

December 25, 2008 at 9:41 am

#917646
RE: Is there a Bug with the Replace() Function in SQL Server 2005

YSLGuru (12/15/2008)
I think I may have come across a bug with the Replace() function in SQL Server 2005.
For what it's worth, I agree... if you compare the way the very...
--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)

December 25, 2008 at 8:45 am

#917636
RE: HAPPY CHRISTMAS & HAPPY NEW YEAR 2009 TO ALL MY FRIENDS

RBarryYoung (12/24/2008)
Sandy (12/23/2008)
HAPPY CHRISTMAS & HAPPY NEW YEAR 2009 TO ALL MY SWEETY FRIENDS...
(GAIL :), GRANT, STEVE, JEFF, RBAR, & ALL SQL GURUs)
You know I am really not crazy about...
--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)

December 24, 2008 at 5:39 pm

#917589
RE: HAPPY CHRISTMAS & HAPPY NEW YEAR 2009 TO ALL MY FRIENDS

Merry Christmas and Happy New Year to you, too, Sandy... and to everyone else, as well.
--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)

December 24, 2008 at 5:38 pm

#917588
RE: Are the posted questions getting worse?

BWAAA-HAAA! Sounds like a heck of a tagline for a new company, Barry 😛
--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)

December 24, 2008 at 5:14 pm

#917587
RE: Aggregate bit operator in TSQL

You know... I've never read one of his books... they any good?
--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)

December 24, 2008 at 5:10 pm

#917586
RE: Get Missing Data with Tally Table

Sure it can... but then why spend all those brain cells trying to do it in a single query when a proc can do the same thing and maybe 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)

December 24, 2008 at 5:04 pm

#917584
RE: Cursors Be Gone!

Matt Whitfield (12/24/2008)
Jeff
You know what, I have to say - would it kill you to agree with what people have said rather than repeat what other people say and try...
--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)

December 24, 2008 at 4:38 pm

#917582
RE: Cursors Be Gone!

Matt Whitfield (12/24/2008)
@jeff -
I tried to test the COALESCE method, but it was horrifically slow over about 10,000 rows. Also interested why you say SELECT COALESCE(@SQL .... when it's actually...
--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)

December 24, 2008 at 4:33 pm

#917581
RE: Cursors Be Gone!

Kurt W. Zimmerman (12/24/2008)
Matt;
Great post! My view on this is if cursors were so bad then why does the construct even exist? Cursors have their place...
--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)

December 24, 2008 at 12:17 pm

#917528
RE: Get Missing Data with Tally Table

What caught my eye was the following...
sognibene (10/23/2008)
I will post what I am able to get working.
That seemed to leave the problem up in the air. I wanted to...
--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)

December 24, 2008 at 11:51 am

#917524

Viewing 15 posts - 46,411 through 46,425 (of 59,101 total)