Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,511 through 3,525 (of 59,086 total)

Reply To: Retrieve last 12 months

Ok... That was an important part for us to know there. With that out of the way, we need to know a few things to be able to help 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)

May 18, 2022 at 1:39 pm

#4034994
Reply To: can i store hashbyte on field with length smaller than fields i concatenate it?

ahmed_elbarbary.2010 wrote:
I work on sql server 2019 i have table have multi column string concatenation as StrSubstance,strmass ,strcasnumber
i need to create filed hashchemical with nvarchar(700) and this will store hash...
--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 17, 2022 at 7:29 pm

#4034504
Reply To: How to get weekly and Monthly view from daily in sql server

So please explain how the 1/1/2021 entry for sales of 100 gets knocked down to only 5 calls in the desired output.
To @ratbak's point about providing DDL, please see 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)

May 17, 2022 at 7:25 pm

#4034503
Reply To: slow execution WHEN update chemical id on table chemicalhash so how to enhance i

p,s. And, yes... I understand what you're trying to do and maybe even why. I just need for you to answer my question about the ChemicalID nulls/non-nulls 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)

May 17, 2022 at 6:18 pm

#4034478
Reply To: slow execution WHEN update chemical id on table chemicalhash so how to enhance i

Does the ChemicalHash table ONLY contain rows where the ChemicalID is NULL or does it have rows where the ChemicalID is not null?

--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 17, 2022 at 6:10 pm

#4034477
Reply To: Retrieve last 12 months

This could be pretty easy but, I have to ask, why are you basing your reporting periods on 365*24/12 - 730 hours = 43,800 minutes = 30.4 days? All 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)

May 17, 2022 at 5:43 pm

#4034472
Reply To: How to validate user if input formate no yyyy-MM-dd for created date ?

Heh... I was wondering what you used for a base date in your example. 😀
Totally agreed on the rest. My current issue is that the increments are clicking by way...
--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 14, 2022 at 9:25 pm

#4033057
Reply To: Drawbacks of having hundreds of data files per database

ScottPletcher wrote:
You were attacking a straw man. I never made anything close to the claim you said I did.
Actually, you did...
ScottPletcher wrote:
Actually, the development team should have nothing to...
--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 14, 2022 at 8:02 pm

#4033036
Reply To: Drawbacks of having hundreds of data files per database

Jeff Moden wrote:
ScottPletcher wrote:
You were attacking a straw man. I never made anything close to the claim you said I did.
Actually, you did...
ScottPletcher wrote:
Actually, the development team should have nothing...
--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 14, 2022 at 8:01 pm

#4033035
Reply To: Drawbacks of having hundreds of data files per database

ScottPletcher wrote:
You were attacking a straw man. I never made anything close to the claim you said I did./quote]
Actually, you did...
ScottPletcher wrote:
Actually, the development team should have nothing to do...
--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 14, 2022 at 8:00 pm

#4033034
Reply To: How to validate user if input formate no yyyy-MM-dd for created date ?

Those would work although those particular dates are a wee bit into the future assuming those are the little-endian count of days since the first of January 1900. One 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)

May 14, 2022 at 7:37 pm

#4033030
Reply To: Flattening of hierarchy

corey lawson wrote:
an aside: Azure Synapse cannot do recursive CTEs (or heirarchyid...), if you happen to be working in that realm.
I settled for a few layers of nested CTEs down to...
--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 14, 2022 at 3:55 am

#4032734
Reply To: how to pass previous week dates in stored proc parameters.

The "base date" for SQL Server for temporal datatypes is 01 Jan 1900 and it has a "Date Serial#" of "0". All other dates are based on the number 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)

May 12, 2022 at 11:28 pm

#4032085
Reply To: how to pass previous week dates in stored proc parameters.

ratbak wrote:
A calendar table is great for that. But if you want to derive it dynamically, and you're always executing on the day following the end of the date range:
--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 12, 2022 at 10:39 pm

#4032080
Reply To: how to pass previous week dates in stored proc parameters.

What would be interesting is to see if the stored procedure actually uses the end date correctly or if you going to miss all but the firs 3.3 milliseconds 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)

May 12, 2022 at 10:31 pm

#4032079

Viewing 15 posts - 3,511 through 3,525 (of 59,086 total)