Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,156 through 7,170 (of 59,072 total)

Reply To: Convert from nvarchar to numeric only if valid number-VAL command like MS Access

frederico_fonseca wrote:
what exactly are you trying to do?
Is it a one time conversion or a view that will be available for querying on the fly going forward?
and do you have...
--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 4, 2020 at 2:08 pm

#3748636
Reply To: Constraint in a column

I agree with the others... you need two tables. One for the transaction HEADER and one for the transaction DETAIL.
I'll also add that even though some folks may provide 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)

May 4, 2020 at 12:27 pm

#3748560
Reply To: DBCC CHECKDB succeeds, Backup succeeds, but RESTORE/VERIFY fails

wturner 57240 wrote:
Allow me to rephrase Problem #1: The log backups intermittently fail to RESTORE.
I have a second server we are trying to get setup to be an off-site log shipping...
--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 9:19 pm

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

Lynn,
Thank you for the very kind words. If someone with your knowledge has claimed that I'm their mentor, then I'm truly humbled. To be honest, you're as much of 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)

May 3, 2020 at 8:54 pm

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

Thank you for the kind feedback. Helluva first post, eh? 😀

--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 8:39 pm

#3748483
Reply To: Representing uncertainty in difficult times

Ah... there's apparently a name for the false or simply untrue memories that people have that have become "The Truth" for them. The first part of the article below is...
--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 6:13 pm

#3748477
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

Viewing 15 posts - 7,156 through 7,170 (of 59,072 total)