Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,336 through 37,350 (of 59,098 total)

RE: Parsing Parameters in a Stored Procedure

Ah... I almost forgot... if you don't really want to do any validation against the code... in other words, you just want to do the split, check out the following...
--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)

August 12, 2010 at 9:17 pm

#1206383
RE: Parsing Parameters in a Stored Procedure

Ok... here we go with the first phase of testing. Sorry it takes so long. It takes a bit of time to put such code together and 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)

August 12, 2010 at 8:58 pm

#1206381
RE: Parsing Parameters in a Stored Procedure

dbuendiab (8/11/2010)
Jeff Moden (8/10/2010)
dbuendiab (8/10/2010)
The performance, being a question sometimes, it's not a point here:
You know, it's really odd that you say that. It's really odd that ANYONE would...
--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)

August 12, 2010 at 5:39 pm

#1206365
RE: Parsing Parameters in a Stored Procedure

CELKO (8/12/2010)
jhood (8/10/2010)
I see what you are saying Jeff, but would you want to do validation if the application did not allow the end user to send invalid data? perhaps...
--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)

August 12, 2010 at 5:04 pm

#1206357
RE: Parsing Parameters in a Stored Procedure

john.moreno (8/11/2010)
Jeff Moden (8/11/2010)
My apologies... I got out of work quite late tonight and only had time for some verbal replies. I'll try to get to the coded replies...
--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)

August 12, 2010 at 5:00 pm

#1206355
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

mtillman-921105 (8/10/2010)
Jeff Moden (8/9/2010)
mtillman-921105 (8/9/2010)
Actually, this breaks a cardinal rule in database design - we are using one column for more than one kind of data. It answers two questions:...
--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)

August 12, 2010 at 8:53 am

#1206067
RE: TSQL Challenge 36 - Create a graph/Chart with TSQL

I guess this is as good a place as any to bitch a little about that site (and I've done it there several times as well).
The "charter" of the site...
--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)

August 11, 2010 at 11:47 am

#1205586
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Howard C. BAchtel-438731 (8/10/2010)
Jeff,
You responded earlier to my question by pointing me to these articles. They are very helpful and I really appreciate it.
Thanks for taking the time 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)

August 11, 2010 at 10:53 am

#1205529
RE: Parsing Parameters in a Stored Procedure

My apologies... I got out of work quite late tonight and only had time for some verbal replies. I'll try to get to the coded replies which will include...
--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)

August 11, 2010 at 12:08 am

#1205160
RE: Parsing Parameters in a Stored Procedure

jhood (8/10/2010)
I see what you are saying Jeff, but would you want to do validation if the application did not allow the end user to send invalid data? perhaps using...
--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)

August 11, 2010 at 12:03 am

#1205157
RE: Parsing Parameters in a Stored Procedure

dbuendiab (8/10/2010)
The performance, being a question sometimes, it's not a point here:
You know, it's really odd that you say that. It's really odd that ANYONE would say that. ...
--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)

August 10, 2010 at 11:48 pm

#1205145
RE: Parsing Parameters in a Stored Procedure

dbuendiab (8/10/2010)
I think XML is good (although too verbose) for storing complex data structures.
I agree... it's way too verbose. It clogs the pipe with 6 to 16 times⁽¹⁾ more...
--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)

August 10, 2010 at 11:37 pm

#1205142
RE: Parsing Parameters in a Stored Procedure

dbuendiab (8/10/2010)
jhood (8/10/2010)
I see what you are saying Jeff, but would you want to do validation if the application did not allow the end user to send invalid data? perhaps...
--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)

August 10, 2010 at 11:16 pm

#1205139
RE: Parsing Parameters in a Stored Procedure

TheSQLGuru (8/10/2010)
Didn't we have a MASSIVE thread here on SSC.com on string parsing, with amazing code samples and wonderful benchmarks??
We did. I tried to voice an objection about using...
--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)

August 10, 2010 at 7:30 am

#1204765
RE: Parsing Parameters in a Stored Procedure

jcboyer-1091017 (8/10/2010)
something like:
set @XMLParameters =
'<OrderGroup>
<Item TargetPrinterType="DIAMOND_X" GroupStatus="ACTIVE_cc" ReferenceNo="Joe" />
</OrderGroup>'
Thanks, Jerome...
--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)

August 10, 2010 at 7:26 am

#1204760

Viewing 15 posts - 37,336 through 37,350 (of 59,098 total)