Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,826 through 48,840 (of 59,093 total)

RE: Trigger Not Executed even if record is inserted or Updated

smunson (8/11/2008)
Jeff,
He appears to just want a copy of the insert, so would replication meet his need, or would that cause problems on speed of "Updation" ?
Steve
(aka smunson)
:):):)
I think replication...
--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, 2008 at 7:25 pm

#856449
RE: Bill Baker

bakerbill (8/11/2008)
Bill will use any method to hurt whoever brings up the painful truth.
Maybe so... but you're pretty good at throwing people under the bus yourself. 😛
It sounds like...
--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, 2008 at 7:19 pm

#856446
RE: BCP Remote Files

Angel Miranda Nieto (8/11/2008)
thank everyone, my problem is solved, we are in contact
Two way street here, Angel... tell us how you solved your problem, please. 🙂
--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, 2008 at 7:12 pm

#856445
RE: SQL Year and Week numbers

jennyor (8/11/2008)
I'm trying to write an update command in sql to take the weekyear portion of a serial # and convert it back to a date by extracting the week...
--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, 2008 at 7:10 pm

#856443
RE: Store word doc/image on sql server

THAT, my friend, it why I recommend only storing the file name and not the file itself. 😛
You either have to capture the info in a variable in 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 11, 2008 at 6:46 pm

#856437
RE: Find distinct special characters in column

shamshad.ali (8/11/2008)
I need to list them down. if there is a way. also how should i exclude space" " and dot"." from [a-z0-9]
Thanks all for help...
Shamshad Ali.
Shamshad... have you tried...
--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, 2008 at 5:59 pm

#856434
RE: How to ignore the comma seperator inside ","

Like I said... Books Online... lookup BCP Format file. I can't help if you don't even know what I'm talking 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)

August 11, 2008 at 5:58 pm

#856433
RE: Get duplicate range - How to

dwither_07 (8/11/2008)
Hmm..let me trace on how did I come up with the said result, I'll just use script number 6 (Sixth Data Scenario) since it has less data.
--=====...
--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, 2008 at 5:55 pm

#856432
RE: Uncommon Table Expressions

Good article so far as the format, readability, and revelation go. The thing I'm having a problem with is the use of recursion of any kind to create 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 11, 2008 at 5:40 pm

#856429
RE: Uncommon Table Expressions

GSquared (8/11/2008)
On CLR, yes, it will be faster than the CTE on that.
Does anyone want to race? 😉
--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, 2008 at 5:20 pm

#856426
RE: Get duplicate range - How to

Um... no... according o the rules you gave, script 5 should include rowid # 11 because the promo-id went from 6 to 1.
--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, 2008 at 11:17 pm

#855881
RE: Get duplicate range - How to

Ok... I've tested all of your scenarios and they all came out like you said in the comments except the 5th one... and that's because you made a mistake... Row_ID...
--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, 2008 at 10:55 pm

#855877
RE: Trigger Not Executed even if record is inserted or Updated

yogesh.khaire (8/10/2008)
Is there any way other than Trigger. ?
But i want fast Updation. when ever Data Inserted or updated in the Table i want to be insert that Data into...
--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, 2008 at 10:48 pm

#855876
RE: Store word doc/image on sql server

...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)

August 10, 2008 at 10:45 pm

#855875
RE: Get duplicate range - How to

Did you test them with the code I gave you because it solves the two originals I posted just exactly as you stated the results should be.
--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, 2008 at 10:44 pm

#855874

Viewing 15 posts - 48,826 through 48,840 (of 59,093 total)