Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,341 through 50,355 (of 59,091 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

jcrawf02 (5/23/2008)
Yeah, I know, but I have limited access to the system, and can't access the system tables at all, or create indexes. Stuck with the while loop for...
--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)

May 23, 2008 at 8:09 am

#819695
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

In case you take Hugo's post to heart...
Yep... I agree... it ain't ANSI. Oracle (and several other RDBMS's) don't have this ability. Lot's of stuff in this world...
--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)

May 23, 2008 at 7:53 am

#819681
RE: Date String

Sorry... didn't mean to get you excited. 🙂
"Flag" a post, in this case, meant that I save the URL for the post in my "Things to follow up on" list...
--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)

May 22, 2008 at 10:48 pm

#819482
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Good stuff, Gus! Looks like I have a couple of more things to play with. Glad you were bored this morning! 🙂
--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)

May 22, 2008 at 7:18 pm

#819460
RE: Date String

Heh... no problem... I didn't remember either... was reviewing old posts that I had flagged 'cause I knew I'd forget.
Thanks for the feedback!
--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)

May 22, 2008 at 6:45 pm

#819459
RE: Should I use sp_rename?

In that case, I think I'd be tempted to use a passthrough view instead of a synonym.
--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)

May 22, 2008 at 6:40 pm

#819456
RE: Getting tables in a like

Cool... if you get the chance, can you post your solution? I'm sure lot's of folks would like to see it.
--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)

May 22, 2008 at 6:39 pm

#819455
RE: XML vs Split for parsing of URL type data

RyanRandall (5/22/2008)
Another XML-style approach...
drop table #Results
; with a as (select RowNum, cast('<parm '+ replace(replace(Parameters,'=','="'),'&','" ')+ '"/>' as xml) as Xml from #SourceTable)
select RowNum,
Xml.value('(parm[1]/@Subject)[1]', 'varchar(255)') as Subject,
...
--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)

May 22, 2008 at 6:33 pm

#819453
RE: how to avoid sp_cursorprepexec and sp_cursorunprepare?

No problem... quick look says they all suffer from the same problems and all are in need of a major rewrite.
Heh... Kevin... I'm right there with you... I've recently been...
--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)

May 22, 2008 at 6:30 pm

#819451
RE: Data Conversion question - To Cursor or not to Cursor, that is the question

Looks like you got it... Thanks for the feedback and for posting your solution.
--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)

May 22, 2008 at 6:22 pm

#819449
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

jcrawf02 (5/22/2008)
All right Jeff, I was having fun with your tally table example and trying to think set-based on how to clean up a column that included non-alpha characters. ...
--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)

May 22, 2008 at 5:55 pm

#819442
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Obscenotron (5/22/2008)
Freakin' awesome article, man. I had no idea such things as these existed. I have seen the light. Thank you!
Now THAT's an awesome compliment! Thanks!
--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)

May 22, 2008 at 4:27 pm

#819421
RE: exec sp_executesql

It would really help if you did two things...
1. Post what the actual error is
2. Post the generated conten of the dynamic SQL code
You may even want 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)

May 22, 2008 at 4:13 pm

#819416
RE: How to get Weeks in a month

You need to define what a "week" is before anyone can help... Do weeks start on a Monday or ??? Are you talking about ISO week #'s or 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)

May 22, 2008 at 4:10 pm

#819414
RE: Datetime Parameter

My pleasure. Thank you for the feedback.
--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)

May 21, 2008 at 11:33 pm

#818990

Viewing 15 posts - 50,341 through 50,355 (of 59,091 total)