Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,436 through 12,450 (of 59,095 total)

RE: The SQL Joke Thread

Why did the DBA get hit by a car? He didn't know how to back 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)

May 2, 2018 at 10:25 am

#1988958
RE: Advanced Data Masking

If, by data masking, you simply mean something like using a mask for viewing purposes, then be aware that such masks are incredibly easy to overcome and you can actually...
--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 2, 2018 at 10:23 am

#1988956
RE: Transpose Rows to column

Aye. Nicely done, Jason.
--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 2, 2018 at 7:44 am

#1988930
RE: Upper Case Lower Case

jonathan.crawford - Wednesday, May 2, 2018 6:14 AM
Jeff Moden - Initial creation 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)

May 2, 2018 at 7:37 am

#1988928
RE: Counting Active records for each month based on date range in 2 columns

Please see the following article. It breaks it down to make it real simple. Although the article is title for the "previous month", it applies to any date range you...
--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 1, 2018 at 8:23 pm

#1988882
RE: Transpose Rows to column

sksingh123 - Tuesday, May 1, 2018 2:58 PM
Can anyone help me to transpose below result
SVR    dates    count
SRV1    03/25/2018    1
SRV1    04/06/2018    59
SRV1    04/07/2018    9
SRV1    04/13/2018    1
SRV1    04/15/2018    1
SRV1    04/20/2018    4
SRV1    04/21/2018    2
SRV1    04/27/2018    5
SRV1    04/28/2018    5
SRV1    04/29/2018    1
SRV1    04/30/2018    62
Date can be variable and the range of...
--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 1, 2018 at 8:19 pm

#1988881
RE: Advanced Data Masking

WebTechie - Tuesday, May 1, 2018 11:07 AM
Steve,
Yes, I saw a demo of that product. That is why I was asking if...
--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 1, 2018 at 11:38 am

#1988826
RE: Number of Days between two Day Names

Thom A - Tuesday, May 1, 2018 9:58 AM
Jeff Moden - Tuesday, May 1, 2018 9:37 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)

May 1, 2018 at 10:04 am

#1988806
RE: Random Word Generation for Data Scrubbing

SQLBlimp - Tuesday, May 1, 2018 7:54 AM
Eirikur Eiriksson - Tuesday, May 1, 2018 7:52 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)

May 1, 2018 at 9:48 am

#1988803
RE: Number of Days between two Day Names

I'll be interesting as hell to see what happens during a "wrap around" when the start day is a Thursday and the end day is a Monday. And what of...
--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 1, 2018 at 9:37 am

#1988800
RE: Random Word Generation for Data Scrubbing

Great job, John. Can you share the link for the dictionary download that you used? I ask because most word lists seem to be rather unabridged when it comes 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)

May 1, 2018 at 6:09 am

#1988749
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Tuesday, May 1, 2018 2:56 AM
ChrisM@Work - Monday, April 30, 2018 10:05 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)

May 1, 2018 at 5:39 am

#1988745
RE: Advanced Data Masking

WebTechie - Monday, April 30, 2018 12:22 PM
Good afternoon.
I was told that we need to obfuscate the pii data in our lower...
--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)

April 30, 2018 at 9:08 pm

#1988719
RE: Change Data format

Jason A. Long - Monday, April 30, 2018 12:32 PM
Jeff Moden - Monday, April 30, 2018 11:54...
--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)

April 30, 2018 at 6:58 pm

#1988718
RE: Updating a column with serial numbers

jcelko212 32090 - Monday, April 30, 2018 11:10 AM
So there's no such thing as a first row, second row, etc.
There...
--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)

April 30, 2018 at 11:57 am

#1988679

Viewing 15 posts - 12,436 through 12,450 (of 59,095 total)