Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 59,082 total)

Reply To: Is it possible? Allocate Identity values before performing insert

I'll also tell you why sys.sp_sequence_get_range will disappoint. The only thing it does is give you the first value and reserves the rest of the values. If you want those...
--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 3, 2023 at 2:13 am

#4225402
Reply To: Is it possible? Allocate Identity values before performing insert

aztec_2step wrote:
I'll look into the sys.sp_sequence_get_range SP as I've seen someone said it is thread safe. This may be a good solution. (if thread safe)
Looking at it from 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)

July 3, 2023 at 12:02 am

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

Jeff Moden wrote:
@anjali66 ,
Just curious... did it work for you after my clarification above?
No answer... Ok then... good luck! 😉
--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 11:43 pm

#4225332
Reply To: Is it possible? Allocate Identity values before performing insert

Post removed.

--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 11:38 pm

#4225331
Reply To: Column Pivot

What's the max oven number and what do you want to count if a "run" straddles the last day and the first day of the month? For example, do 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)

July 2, 2023 at 11:25 pm

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

Viewing 15 posts - 1,351 through 1,365 (of 59,082 total)