Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,966 through 10,980 (of 59,099 total)

RE: Compare of variables and handling nulls

allan.ford17 - Sunday, October 14, 2018 9:18 PM
Hi,
I wanted to compare 3 variables and set a flag if any of the three...
--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)

October 14, 2018 at 10:53 pm

#2009533
RE: Are the posted questions getting worse?

Let it die.
--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)

October 14, 2018 at 10:46 pm

#2009531
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Sunday, October 14, 2018 9:28 AM
He he, be my guest!
😎
This prat doesn't know that this...
--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)

October 14, 2018 at 10:03 am

#2009513
RE: Multiple lines text insert into varchar(Max) column

adonetok - Friday, October 12, 2018 7:45 AM
From a ASP.NET app, there is a multiple line text box.
If user input text like...
--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)

October 14, 2018 at 6:56 am

#2009507
RE: HOW TO GET FIRST DATE

Deny_Christian - Monday, September 17, 2018 12:54 AM
Dear all,
I have data like:

NAME ...
--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)

October 14, 2018 at 6:53 am

#2009506
RE: Are the posted questions getting worse?

GilaMonster - Saturday, October 13, 2018 11:43 AM
Jeff Moden - Saturday, October 13, 2018 10:15 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)

October 13, 2018 at 1:11 pm

#2009501
RE: Importing CSV Flat File defaults all columns to 50 chars

Duncan A. McRae - Saturday, October 13, 2018 9:19 AM
Same name, same issue. Any resolution in the 8 years since posted?
IMHO, 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)

October 13, 2018 at 12:04 pm

#2009499
RE: A $3 Billion Donation

I'm not sure that's generosity on the part of Microsoft. Perhaps, and as many have, Microsoft finally woke up as to how much money it costs to police and protect...
--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)

October 13, 2018 at 11:48 am

#2009497
RE: What's wrong with my table?

frederico_fonseca - Friday, October 12, 2018 6:01 PM
Unless this is a datawarehouse (and even that not a must) then lots are wrong.
See...
--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)

October 13, 2018 at 11:04 am

#2009495
RE: What's wrong with my table?

Hmmm.... based on other posts by this op, this is all starting to sound a bit different than what the actual wording of the post might convey. Please see...
--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)

October 13, 2018 at 11:03 am

#2009494
RE: Are the posted questions getting worse?

frederico_fonseca - Saturday, October 13, 2018 10:52 AM
Jeff Moden - Saturday, October 13, 2018 10:15 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)

October 13, 2018 at 11:01 am

#2009493
RE: Anyone see a problem with this?

Hmmm.... this is all starting to sound a bit different than what the actual wording of the post might convey. Please see the following...
https://www.sqlservercentral.com/Forums/2002689/Query-slow-Help-improve?Update=1#bm2002914
--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)

October 13, 2018 at 10:36 am

#2009491
RE: Query slow. Help improve?

Heh... I just saw your other post on the monster wide table that violated every form of normalization there is and where every update was preserved without the benefit of proper historical...
--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)

October 13, 2018 at 10:25 am

#2009490
RE: Are the posted questions getting worse?

Jeff Moden - Saturday, October 13, 2018 9:42 AM
Eirikur Eiriksson - Saturday, October 13, 2018 3:54 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)

October 13, 2018 at 10:16 am

#2009488
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Saturday, October 13, 2018 3:54 AM
frederico_fonseca - Saturday, October 13, 2018 3:12 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)

October 13, 2018 at 9:42 am

#2009482

Viewing 15 posts - 10,966 through 10,980 (of 59,099 total)