Forum Replies Created
Viewing 15 posts - 6,601 through 6,615 (of 59,091 total)
-
Reply To: How to remove quote marks using SSIS and a little C#
David Burrows wrote:Jeff Moden wrote:Yes, you still need to deliberately get rid of the first character in the first column and the last character in the last column (because they're quotes) but...
--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) -
Reply To: Are the posted questions getting worse?
Heh... all good guesses but... nope.
--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) -
Reply To: Recover database encrypted modules code with dbatools
Agreed... thanks for sharing this.
As a bit of a sidebar, there have been many cool hacks to decrypt encrypted code in SQL Server since very shortly after the method came...
--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) -
Reply To: sql2016 - if column cell changes, insert value into another column cell
jayM wrote:I am trying to retrieve the blue-highlighted based on MR#.
-if MR# is different from last (5 to 6), retrieve 16.30, if MR# is different from last, retrieve 16.85, and...
--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) -
Reply To: How to remove quote marks using SSIS and a little C#
Gosh, folks... if we look at the example from the article...
There's no need for all the special handling if you make 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) -
Reply To: sql2016 - if column cell changes, insert value into another column cell
jayM wrote:Our process:
- <li style="list-style-type: none;">
- We have masterRolls#
- <li style="list-style-type: none;">
- We cut into 5 slices per that roll, but it could be 2 slices, could be up 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) -
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:Jeff Moden wrote:On the same note, you're not yet told me what you think the 3|8 number means in the life of a DBA. My hint would be "It Depends"...
--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) -
Reply To: Hidden RBAR: Counting with Recursive CTE's
david.edwards 76768 wrote:At the risk of sounding like a crazy stalker, I'm glad I started "following" you on this forum Jeff, I can usually guarantee that a thread you pop up...
--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) -
Reply To: Location Data Privacy
Eirikur Eiriksson wrote:bestofphx wrote:Yep. This is why I use a dumb phone. Less distraction and none of my data is being used. Wonderful.
Bit of a misconception here, there is a lot...
--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) -
Reply To: Location Data Privacy
bestofphx wrote:Yep. This is why I use a dumb phone. Less distraction and none of my data is being used. Wonderful.
Interesting. What is the make and model of the dumb...
--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) -
Reply To: Are the posted questions getting worse?
On the same note, you're not yet told me what you think the 3|8 number means in the life of a DBA. My hint would be "It Depends" on how...
--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) -
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:And here I was thinking that
0x383338313736
8 3 8 1 7 6was far too obvious of a hint
😎
It absolutely was obvious... it just 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) -
Reply To: How to compare strings by letters in certain places
Jason A. Long wrote:Just for the fun of it, I decided to change it up so that will identify all of the position/character matches and tell you what the positions are and...
--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) -
Reply To: How to compare strings by letters in certain places
BOR15K wrote:Thank you, Jeff!
You bet. Thank you for the feedback on what this is going to be used for.
--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) -
Reply To: Are the posted questions getting worse?
Eirikur Eiriksson wrote:Jeff Moden wrote:Eirikur Eiriksson wrote:Gents, you can do better than that!
😎
Now think inside your (tool)box!
Heh... lordy. You need to use the tool to spell the tool...
SELECT CONCAT(CHAR(838176/10000),CHAR(838176/100%100),CHAR(838176%100));
--=====...--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)
Viewing 15 posts - 6,601 through 6,615 (of 59,091 total)