Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,576 through 4,590 (of 59,087 total)

Reply To: Conversion failed when converting date and/or time from character string

carlton 84646 wrote:
Thank you Jeff. Spot on. Thanks
Scott was the first to respond. 😉
--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)

September 27, 2021 at 11:16 am

#3933430
Reply To: How to calculate Monthly aggregates from daily data

asita wrote:
Thank you very much Jeff. I noticed one thing if there is none changed in the latest month it is not showing any record for the month it would...
--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)

September 27, 2021 at 10:35 am

#3933422
Reply To: How to calculate Monthly aggregates from daily data

asita wrote:
Data output is for information what output columns expected etc. may not need to exactly match. but around.
Thank you much and apologize for the troublesome code
asiri
Just remember... If 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)

September 27, 2021 at 2:05 am

#3933313
Reply To: How to calculate Monthly aggregates from daily data
That was just one of the problems with the data v.s. what you wanted for the output.
Anyway, here's the code you need.
```
WITH cte AS
(
 SELECT  FileMonth...
```
--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)
September 27, 2021 at 1:53 am

#3933310
Reply To: How to calculate Monthly aggregates from daily data

The latest version of the code works just fine now. I also took a look at your expected output. We don't need to create any code to know that 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)

September 27, 2021 at 1:12 am

#3933303
Reply To: How to calculate Monthly aggregates from daily data

You really need to actually try to run the code you posted before you post it. Heh... you even apparently ignored what I told you what was wrong with 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)

September 27, 2021 at 12:01 am

#3933290
Reply To: GUIDs as clustered index

Ok. That sounds like the only reason you're adding the GUID is to try to avoid fragmentation. By itself, that's probably not a good enough reason. And, again, there's no...
--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)

September 26, 2021 at 11:54 pm

#3933287
Reply To: Conversion failed when converting date and/or time from character string

Not to mention "Y", "N", month names with no reference to a year and much more.
--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)

September 26, 2021 at 11:05 pm

#3933279
Reply To: How show only first friday of every month

I definitely have an appreciation for the "old" days. I used to be able to read the holes on a Hollerith card and tell you what it said. 😀
So, thanks...
--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)

September 26, 2021 at 10:11 pm

#3933271
Reply To: GUIDs as clustered index

Call it what you want, using a GUID to "represent the PK" or vice versa makes no sense to me. Both columns are fixed width (unless you've done row or...
--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)

September 26, 2021 at 9:59 pm

#3933266
Reply To: How to calculate Monthly aggregates from daily data

I really appreciate what you tried to do with the readily consumable data but it's broken. The table creation is broken and the table to be inserted into is not...
--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)

September 26, 2021 at 9:50 pm

#3933265
Reply To: GUIDs as clustered index

To be honest and with the understanding that I have no real good grip on what your processes require, I see no serious merit in having both the IDENTITY column...
--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)

September 26, 2021 at 7:29 pm

#3933240
Reply To: GUIDs as clustered index

Steve Collins wrote:
vsamantha35 wrote:
So, they came up with a workaround as below.
- Introduced a new column as BIGINT column. - Made the bigint column as NOT NULL IDENTITY(1,1) with clustered...
--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)

September 26, 2021 at 4:05 pm

#3933218
Reply To: Volunteer For Something

Grant Fritchey wrote:
meelan wrote:
Hi Grant
Nice post and Thanks
By the way, what is your call sign?
KC1KCE
And thanks.

At home, apparently my call sign is "DINNER!" 😀
--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)

September 25, 2021 at 6:03 pm

#3933076
Reply To: How show only first friday of every month

On the "hoping" thing, that was just a bit of "before I had enough coffee" conversation. 😀
On Zidar's approach, and like I said in my response, the method that he...
--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)

September 25, 2021 at 6:00 pm

#3933073

Viewing 15 posts - 4,576 through 4,590 (of 59,087 total)