Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,901 through 12,915 (of 59,095 total)

RE: Need to get consecutive duplicate rows

Understood and appreciated. But you're only focusing on what the OP asked. While that certainly sounds like the right thing to do, even the OP has made no guarantee 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)

February 18, 2018 at 8:24 am

#1980196
RE: Today's Random Word!

DesNorton - Saturday, February 17, 2018 11:59 PM
Jason A. Long - Saturday, February 17, 2018 6:03 PM
--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)

February 18, 2018 at 8:05 am

#1980195
RE: Show results based on String Search

shyamhr - Sunday, February 18, 2018 1:11 AM
I agree with you Jeff. I wish I could do that. Lol....
Heh... understood and much appreciated. ...
--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)

February 18, 2018 at 8:01 am

#1980194
RE: XP_cmdshell DIR

Jeff Moden - Saturday, February 17, 2018 6:04 PM
SQL-DBA-01 - Thursday, April 23, 2015 9:55 AM
--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)

February 17, 2018 at 6:05 pm

#1980191
RE: XP_cmdshell DIR

SQL-DBA-01 - Thursday, April 23, 2015 9:55 AM
Can you please suggest all the files from one location to another using the temp...
--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)

February 17, 2018 at 6:04 pm

#1980190
RE: Show results based on String Search

shyamhr - Saturday, February 17, 2018 2:26 PM
Thanks Jeff for the idea. I actually implemented the same idea you said. I penned...
--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)

February 17, 2018 at 4:14 pm

#1980186
RE: Need to get consecutive duplicate rows

Jacob Wilkins - Saturday, February 17, 2018 2:33 PM
Jeff,
Well aware of that. It was not specified that an id of, say, 7...
--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)

February 17, 2018 at 4:11 pm

#1980185
RE: Need to get consecutive duplicate rows

Jacob Wilkins - Friday, February 16, 2018 2:49 PM
I know the post is in a 2012 forum, but just in case, here'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)

February 17, 2018 at 1:44 pm

#1980180
RE: Need idea on exporting column data to separate file -ssis

Heh... they won't allow you to use xp_CmdShell because they think it's a security risk (it's patently NOT when used correctly) but they will let you call a C# script...
--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)

February 17, 2018 at 1:09 pm

#1980177
RE: Show results based on String Search

shyamhr - Friday, February 16, 2018 5:10 PM
Hi Everyone,
I have a complex...
--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)

February 17, 2018 at 12:37 pm

#1980176
RE: @@OPTIONS

Heh... although it certainly does return a single integer (which is the answer I chose based on a coin flip between A and C), answer C is actually much 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)

February 17, 2018 at 12:26 pm

#1980175
RE: Memory Optimized FileGroups

Grant Fritchey - Saturday, February 17, 2018 8:49 AM
Yeah, you can create the table variables into the In-Memory storage and it really...
--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)

February 17, 2018 at 12:02 pm

#1980174
RE: Are the posted questions getting worse?

jonathan.crawford - Friday, February 16, 2018 5:36 PM
Sean Lange - Friday, February 16, 2018 1:19 PM
--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)

February 17, 2018 at 6:56 am

#1980165
RE: Using Hex values

Jason A. Long - Friday, February 16, 2018 1:04 PM
Jeff Moden - Friday, February 16, 2018 12:53...
--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)

February 16, 2018 at 2:06 pm

#1980138
RE: Using Hex values

Jason A. Long - Friday, February 16, 2018 12:40 PM
Jeff Moden - Friday, February 16, 2018 11:20...
--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)

February 16, 2018 at 12:53 pm

#1980125

Viewing 15 posts - 12,901 through 12,915 (of 59,095 total)