Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 59,067 total)

Reply To: Adding Week Numbers by Month

With the aim to help get rid of that Cursor/While Loop and remove some "rust" in the process 😀 , what does the CA4 column contain.?
--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)

July 2, 2023 at 8:18 pm

#4225231
Reply To: Adding Week Numbers by Month

JettaBar99 wrote:
I am trying to add week number by month so Feb would have weeks 1 -4, March 1-5 etc.
To be sure, the reason why I'm asking questions is because...
--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)

July 1, 2023 at 4:47 pm

#4224434
Reply To: Fact Table - Various Grains

I apologize... This slipped off my radar. Hopefully, you found an answer but I notice that you updated the question a day ago.
To be honest, I'm not sure, from your...
--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)

July 1, 2023 at 3:13 pm

#4224374
Reply To: Find spaces between First and Last Name in Microsoft SQL

@anjali66 ,
Just curious... did it work for you after my clarification above?
--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)

July 1, 2023 at 3:40 am

#4223983
Reply To: BCP works in 2016 but not in 2022 during migration.

Well, we solved it.
To summarize, everything with the actual migration worked perfectly except for one thing (ok, call it two.. I bunched it together as "comms with other machines"). Neither...
--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)

July 1, 2023 at 12:12 am

#4223867
Reply To: BCP works in 2016 but not in 2022 during migration.

Thanks, Frederico. One of the other ones I looked at said to change all the code to use a name and password. The one for Pinal Dave with the download...
--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)

June 30, 2023 at 6:10 pm

#4223638
Reply To: Correcting fact table records that were changed by a user

What I'm getting at is that if users at the end need to make changes for reporting or whatever, there is something seriously wrong with the source of data 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)

June 28, 2023 at 8:13 pm

#4221892
Reply To: Correcting fact table records that were changed by a user

Chrissy321 wrote:
I probably should have stated my use case. It's not a traditional data warehouse but rather a tabular model on which PowerBI reports are built for analysis/business intelligence. 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)

June 27, 2023 at 5:31 pm

#4220870
Reply To: Correcting fact table records that were changed by a user

I have to agree with Kimball. Never update a fact table. Only update the source of the data that the fact table was generated from and do the ETL thing...
--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)

June 26, 2023 at 7:44 pm

#4220048
Reply To: T-SQL the Problem with Scalar Functions breaking Parallelism

Johan Bijnens wrote:
Scalar functions are still a big NoNO ! ( Inlining doesn't work on all SVFs !! ) Write your SVFs as InlineTableValueFunctions and things will perform again
To that end,...
--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)

June 24, 2023 at 8:08 pm

#4218563
Reply To: Find spaces between First and Last Name in Microsoft SQL

Anjali66 wrote:
I only have select permission on this table. This is a third party vendor database and I cannot update/delete/insert or create procedure/functions in this database. I am getting the...
--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)

June 24, 2023 at 3:38 am

#4218066
Reply To: Find spaces between First and Last Name in Microsoft SQL
```
--======================================================================================================
--      Create and populate the test table. This is not a part of the solution.
--======================================================================================================
--===== Create the test table.
   DROP...
```
--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)
June 23, 2023 at 4:33 pm

#4217744
Reply To: T-SQL the Problem with Scalar Functions breaking Parallelism

I write functions as an "ISF", a term that MS created a very long time ago in some now extinct documentation because they never created an "Inline Scalar Function". As...
--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)

June 23, 2023 at 3:50 pm

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

Michael L John wrote:
Jeff Moden wrote:
I'm thinking that you need to be more clear on the job description that you use to hire people... a LOT more clear. For more than just...
--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)

June 22, 2023 at 11:58 pm

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

Michael L John wrote:
Well, here is a new one.
While reviewing design standards with a set of contract developers we pointed out that any object needs to be qualified with the schema 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)

June 22, 2023 at 7:20 pm

#4217022

Viewing 15 posts - 1,336 through 1,350 (of 59,067 total)