Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,236 through 50,250 (of 59,099 total)

RE: Array Processing - CLR or TSQL?

Thanks for the feedback, David!
--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 30, 2008 at 9:14 am

#822402
RE: Shifting columns

Welcome aboard, Steve! And 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 30, 2008 at 9:13 am

#822400
RE: Function to convertbinary to varchar

OP is passing in Varbinary... I guess I don't understand... what does the input actually look like and what should the output be?
Are you suggesting that the input is 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)

May 29, 2008 at 9:46 pm

#822081
RE: Sorting the Sheep from the Goats

Nightstick recalibration or just a crushing blow to the calcium knob?
--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 29, 2008 at 9:35 pm

#822079
RE: load a csv file

Thanks for the feedback, Bob. Yeah, it's sometimes very difficult to simply ignore such a post... but I should get better at just blowing those types of posts off...
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 29, 2008 at 9:31 pm

#822077
RE: random Number

bcronce (5/29/2008)
select convert(bigint,HashBytes('SHA1', convert(varchar, getdate(),121)+convert(varchar,rand())))
this should be a bit unique:cool:
It is, but not if you use it in a single select against a multi-row table to try to generate 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)

May 29, 2008 at 9:26 pm

#822074
RE: Shifting columns

Nicely done, Steve... Because of the nature of the CHAR datatype and the fact that the orginal table uses it instead of VARCHAR, you can really shorten the code...
--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 29, 2008 at 9:09 pm

#822071
RE: To get next working date for the given date...

steveb (5/28/2008)
Tomm Carr (5/27/2008)
An identity column? Why? What purpose does it serve? Under what circumstances would you ever use it?
an Identity column is required for replication, this 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)

May 29, 2008 at 8:12 pm

#822059
RE: Function to convertbinary to varchar

No UDF required... certainly, no CLR required... 😉
DECLARE @Varbinary VARBINARY(8000)
SET @Varbinary = 0x5468697320697320612074657374
SELECT @Varbinary
SELECT CAST(@VarBinary AS VARCHAR(8000))
--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 29, 2008 at 10:19 am

#821850
RE: Skip n rows while importing from Excel Sheet...

The rest of the code should be pretty simple to figure out... create a table and use the Select I posted as part of an INSERT/SELECT
--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 29, 2008 at 9:35 am

#821824
RE: load a csv file

Yep, I agree... but newbies also have a responsibility... they need to leave their frustration and bad attitude at home. Walking into a forum with words like "I'm fed...
--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 29, 2008 at 9:24 am

#821820
RE: Forum Etiquette: How to post data/code on a forum to get the best help

I've been guilty of that myself. Good reminder, John. 🙂
--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 29, 2008 at 9:21 am

#821816
RE: US Client Expectation

Doesn't matter... I have some fellow Americans that I can't understand sometimes... I do just like I would do with anyone else... I say "I heard you, but I couldn'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)

May 28, 2008 at 6:49 am

#821138
RE: Execute store procedure from BCP

Not sure why the dilema... error message says what's wrong. You've either not installed it when you installed SMS or it's simply not available on the machine that you're...
--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 28, 2008 at 6:45 am

#821136
RE: Sorting the Sheep from the Goats

majorbloodnock (5/28/2008)
Oh, no; I forgot. We're hiring a DBA, not a consultant. My mistake 😀
Heh... some of us consultants ain't so bad... 😀
... but I do understand what you mean.
--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 28, 2008 at 6:34 am

#821129

Viewing 15 posts - 50,236 through 50,250 (of 59,099 total)