Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,186 through 7,200 (of 59,091 total)

Reply To: Have txt/csv files, but header need to find from which row it will start

Excellent. I'll get back to it later tonight then.
--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 3, 2020 at 5:18 pm

#3748470
Reply To: join - how to get only the first row from the left table
JackIsJack wrote:
Please consider that I am not a native english speaker ; let me know if I am not understandable and I'll do my best to clarify.
1. Good Sir, 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 3, 2020 at 5:09 pm

#3748469
Reply To: Representing uncertainty in difficult times

Hmmmph... errors in reporting because of "uncertain data" aren't what's happening. It's outright sensationalism that's happening. To the point of your very accurate second sentence in your good article, which...
--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 3, 2020 at 2:08 pm

#3748452
Reply To: Are the posted questions getting worse?

Jonathan AC Roberts wrote:
Neil Burton wrote:
Jeff Moden wrote:
Heh... let the silliness continue. I just got an email saying...
KILL 99.9% OF BACTERIA & HARMFUL MICROBES
FORMS A PROTECTIVE SHIELD THAT DELAYS GROWTH OF HARMFUL MICROBES ON...
--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 3, 2020 at 4:52 am

#3748400
Reply To: a good book on stored procedures

With that, I'll ask you why do you want to limit yourself in such a fashion? Even books that were written by the combined efforts of multiple authors are usually...
--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 3, 2020 at 4:04 am

#3748396
Reply To: join - how to get only the first row from the left table

JackIsJack wrote:
Hello,
I started learning T-SQL 4 years ago and this is the first time I come here so...nice to meet to you 🙂 !
Here is a simple case : header...
--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 3, 2020 at 2:16 am

#3748394
Reply To: Have txt/csv files, but header need to find from which row it will start
Almost done with setting up some substantial test data for this thread but I need some more information.
1. Will the embedded header (the line with ID,name,sal on it) ALWAYS 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)
May 2, 2020 at 6:08 pm

#3748367
Reply To: Have txt/csv files, but header need to find from which row it will start

Just a little feedback... I finally have some time today to work on this. Actually, I started on it last night.
--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, 2020 at 1:57 pm

#3748345
Reply To: Are You Ready To Change Your Work Environment?

-=JLK=- wrote:
This is my first time doing telework full time. It's been just over a month and we have one more month to go. It has worked out so well...
--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, 2020 at 6:05 pm

#3748198
Reply To: SQL jobs failed

Ant-Green wrote:
Whats the full error message you get.
Renaming disabling the actual SA account is fine jobs can still be owned by that account, that is what I do on my...
--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, 2020 at 12:32 pm

#3748025
Reply To: Are You Ready To Change Your Work Environment?

I used to work from home in the mornings, work in the office from about noon to 8 (and not get much done because of all the "drive by shootings"),...
--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, 2020 at 12:30 pm

#3748008
Reply To: find and replace text in sproc

Thomas Rushton wrote:
The idea of doing a DROP & CREATE fills me with dread - all the bespoke permissions you could lose...
Ditto that. Since this is a 2019 thread, I'm thinking...
--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, 2020 at 12:07 pm

#3748005
Reply To: Where AI Shines

DinoRS wrote:
First of all: it would need to be UV-C specifically, that's the one you're not catching with your sunscreen lotion and most importantly: You should know that injection 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)

April 30, 2020 at 4:45 pm

#3747759
Reply To: A Security Regression

No... the bottom line is that no security is perfect especially from inhouse attacks. I got a report yesterday that even "Zoom" has been hacked an the account information 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)

April 30, 2020 at 4:31 pm

#3747746
Reply To: Have txt/csv files, but header need to find from which row it will start

I'm at work now and can't help just now. I'll have a go at it tonight after work.

--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, 2020 at 2:35 pm

#3747692

Viewing 15 posts - 7,186 through 7,200 (of 59,091 total)