Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,336 through 7,350 (of 59,091 total)

Reply To: Saving integers as varchar so that I can choose '' (empty) as content

jonas.gunnarsson 52434 wrote:
Try normalize the Employee table, to move out rows that may me NULL. Good normalization also gives more understanding of the model. Sometimes NULL, may be acceptable, e.x. 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)

April 9, 2020 at 2:05 pm

#3741778
Reply To: Iterating Over Calculated Tables using Power Query

Gouri Shankar wrote:
@jeff-moden, Yes, I agree with you that the steps I'm trying to get through Power Query can also be done with T-SQL. The main purpose of this article was...
--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 9, 2020 at 1:58 pm

#3741773
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

christoph.kauflin wrote:
I'm curious as to why any row in an Employee table would ever have a NULL (or a -1 alternative or an "empty" alternative) for the Employee number 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 9, 2020 at 1:15 pm

#3741762
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown,...
--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 9, 2020 at 1:11 pm

#3741761
Reply To: bcp format file and import fixed width text file

smattiko83 wrote:
Thanks. I think they are the same when including spaces. They come from the government as a .dat file and they won't change so I'm stuck with these. I've...
--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 9, 2020 at 1:09 pm

#3741759
Reply To: SUM only numbers in varchar column
Phil Parkin wrote:
```
SELECT t.userid
      ,t.rid
      ,Total = SUM(TRY_CAST(t.value AS INT))
FROM temp t
GROUP BY t.userid
    ...
```
--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 9, 2020 at 4:18 am

#3741657
Reply To: different state on the same error message

OrangeBronco wrote:
Chris Harshman wrote:
DamianC wrote:
Does it store these states anywhere though?
State is not really a part of the error itself, but extra information that is added when RAISERROR is called that...
--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 9, 2020 at 4:15 am

#3741656
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

christoph.kauflin wrote:
If I chose to save the employee number as a varchar, I could store '' (empty), which I would prefer.
frederico_fonseca wrote:
DON'T do it is the correct answer. All columns...
--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 9, 2020 at 4:07 am

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

Grant Fritchey wrote:
Steve Jones - SSC Editor wrote:
Michael L John wrote:
Well, the big company meeting announcing what changes will be made was held this morning. I will still have a job, but everyone making over 60k 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)

April 9, 2020 at 4:02 am

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

Steve Jones - SSC Editor wrote:
It's interesting. A friend was over last night. He has 400+ reports under him. Had to let 10% go at the beginning of the year. Easy to do. Got...
--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 9, 2020 at 4:00 am

#3741653
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

jcelko212 32090 wrote:
>> Employee numbers are not numbers!
Heh... I'll go ahead and disagree with you again, Joe. There's no reason why "identifiers" cannot be numbers.
--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 9, 2020 at 3:54 am

#3741652
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

Jonathan AC Roberts wrote:
Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown, -2 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 9, 2020 at 3:50 am

#3741651
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

Ken McKelvey wrote:
Sorry for my blanket statement about NULLs - EndDate and Payment are good examples of when not to use them.
I am afraid I disagree with you about codes. Sooner...
--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 9, 2020 at 3:44 am

#3741650
Reply To: Iterating Over Calculated Tables using Power Query

Ok... I got cricket's on that question... Here's what I'm talking about...
In the article, it first shows Step 1 as a T-SQL query to get the data "into" the Power...
--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 9, 2020 at 1:20 am

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

Michael L John wrote:
Well, the big company meeting announcing what changes will be made was held this morning. I will still have a job, but everyone making over 60k is getting an...
--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 8, 2020 at 6:30 pm

#3741543

Viewing 15 posts - 7,336 through 7,350 (of 59,091 total)