Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,316 through 42,330 (of 59,098 total)

RE: differiniate quotes as data vs quotes as column identifier

Heh... yeah, I forgot about that. Add TOP 2000000000 to the SELECT in the CTE. Don't use TOP 100%... although I haven't had the time to verify 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 14, 2009 at 1:17 pm

#1039651
RE: Are the posted questions getting worse?

GilaMonster (8/14/2009)
I called this evening to ask if there were any known problems, because I've been having intermittent problems since yesterday morning. Help desk replied that there were no issues...
--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 14, 2009 at 1:12 pm

#1039645
RE: Issue with assigning candidates to a review list

RBarryYoung (8/14/2009)
Jeff Moden (8/14/2009)
RBarryYoung (8/11/2009)
WayneS (8/11/2009)
...
BTW, I think Jeff calls it the "pseudo-cursor". Isn't it Phil that calls it the "quirky update"?
Nah, that's me. Jeff hates the term "pseudo-cursor"...
--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 14, 2009 at 11:07 am

#1039565
RE: Issue with assigning candidates to a review list

RBarryYoung (8/14/2009)
Wayne: Any chance we could get some Create Table defs & sample data Inserts?
See Paul's post... it's the same stuff as before (I think).
--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 14, 2009 at 11:05 am

#1039563
RE: Issue with assigning candidates to a review list

RBarryYoung (8/11/2009)
WayneS (8/11/2009)
...
BTW, I think Jeff calls it the "pseudo-cursor". Isn't it Phil that calls it the "quirky update"?
Nah, that's me. Jeff hates the term "pseudo-cursor" and much prefer's...
--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 14, 2009 at 10:41 am

#1039541
RE: Transfering content of a string variable to a file in a SP

Ah.... my bad, Nigel. More coffee please. :blush: I was thinking of the returns from some commands. Thank you for the catch.
Still, 8191 can be 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)

August 14, 2009 at 10:19 am

#1039515
RE: Transfering content of a string variable to a file in a SP

Command lines are limited by the system to only 255 characters and I don't know if they can actually be of the NVARCHAR data type (never tried it). Obviously, VARCHAR(MAX)...
--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 14, 2009 at 9:18 am

#1039447
RE: 'Add' to a character.

Lowell (8/14/2009)
you cannot reuse the numbers if there are gaps...at least not easily.
I'd like to add to that.... there is no reason to "fill in the gaps". If 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)

August 14, 2009 at 9:13 am

#1039444
RE: Getting away from a lookup table, how?

josh.d.kelly (8/13/2009)
I am a web developer trying to become a better database designer. I have been reading about keeping away from lookup tables.
Do you have a URL where you've 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)

August 14, 2009 at 12:44 am

#1039167
RE: differiniate quotes as data vs quotes as column identifier

Do what the comments in the following state and try it again. Let me know if it helped...
;WITH
cteSplit AS
(
SELECT s.RowNum,
Element = ROW_NUMBER() OVER (PARTITION BY...
--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 14, 2009 at 12:21 am

#1039164
RE: SQLServerCentral Editorial Policy - Article Publication

Heh... I had similar feelings about some of the posts. Some of it was so wrong I was moved to say "I'll also say that a lot of 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)

August 13, 2009 at 10:40 pm

#1039137
RE: differiniate quotes as data vs quotes as column identifier

Post the code you're currently using and let's have a look.
--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 13, 2009 at 10:12 pm

#1039130
RE: SQLServerCentral Editorial Policy - Article Publication

RBarryYoung (8/13/2009)
Jeff Moden (8/13/2009)
You've mistaken what I said but, looking back at it, I can see how. I put no words in your mouth or at least I didn't...
--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 13, 2009 at 10:03 pm

#1039128
RE: SQLServerCentral Editorial Policy - Article Publication

You've mistaken what I said but, looking back at it, I can see how. I put no words in your mouth or at least I didn't mean to... 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)

August 13, 2009 at 9:47 pm

#1039121
RE: SQLServerCentral Editorial Policy - Article Publication

Gift Peddie (8/13/2009)
I am troubled by the lynch mob it kills desire and keeps people away.
As usual, your timing is perfect... I agree that many simply refuse to participate in...
--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 13, 2009 at 9:15 pm

#1039116

Viewing 15 posts - 42,316 through 42,330 (of 59,098 total)