Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,656 through 5,670 (of 59,089 total)

Reply To: sql ocde picking last date of month value

imranazam wrote:
Hi guys
hope you are all well
I am struggling to write a sql code which will pick up the sales value of the last date of each month.
I have this...
--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)

February 15, 2021 at 7:41 pm

#3845346
Reply To: Is there room for independent SQL or Data Integration based User Groups?

Tom Uellner wrote:
samalex wrote:
I've also looked at some other SQL Users Groups to see how they work, and thus far I haven't seen any that still meet.
The New England SQL...
--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)

February 15, 2021 at 6:03 pm

#3845307
Reply To: Is there room for independent SQL or Data Integration based User Groups?

I agree that "if you build it, they will come". It does take a bit of advertising and one popular way to do that is to schedule regular meetings/events on...
--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)

February 14, 2021 at 3:36 pm

#3844915
Reply To: Looking for an experienced DB Administraor and Engineer

I'm not looking for a job and I live across "the pond" but I wanted to thank you for posting a job here in these trying times.
--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)

February 14, 2021 at 3:23 pm

#3844902
Reply To: Cursor and Subtraction Assignment Logic Issue

Put yourself in my place and pretend you know absolutely nothing about the problem that you just described and then read what you just posted and compare that to 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)

February 14, 2021 at 4:39 am

#3844788
Reply To: Server is fast, then slow, then fast with no pattern "Solved?"

Jocar26 wrote:
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19042: )
I...
--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)

February 13, 2021 at 5:30 pm

#3844635
Reply To: Convert International Character-String Date Formats

Totally agreed... even when a time isn't included. 😀 There's this funny little line called the "International Date Line" that people seem to forget about.
--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)

February 13, 2021 at 5:25 pm

#3844634
Reply To: Convert International Character-String Date Formats

Heh... and there was a response in the morning's email right next to this one that drives the point home for the bottom line above. The "devil's in the data". ...
--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)

February 13, 2021 at 3:05 pm

#3844597
Reply To: Convert International Character-String Date Formats

Kristen-173977 wrote:
Jeff Moden wrote:
Such a list exists in SQL Server in the sys.syslanguages system compatibility view
Much better idea 🙂 That will also bring to light, and allow checking for, any month...
--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)

February 13, 2021 at 3:01 pm

#3844596
Reply To: SQL newbie, question about primary key.

Ed Wagner wrote:
Everyone's already addressed the SSN and I'm glad it was hypothetical. Kristin hit the nail on the head regarding the PK. The only thing I'd say to watch out...
--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)

February 13, 2021 at 4:57 am

#3844475
Reply To: Looking to Role Models

From the Article:
The SQL Server community has shared, inspired, and supported each other in a way I haven't seen in other areas.
You're one of the people that started that, Steve. ...
--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)

February 13, 2021 at 4:48 am

#3844474
Reply To: Convert International Character-String Date Formats

Kristen-173977 wrote:
If each individual file is not language specific (i.e. dates within the file are mixture of languages) my inclination would be to extract all the DISTINCT month names, ideally...
--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)

February 13, 2021 at 4:12 am

#3844473
Reply To: Convert International Character-String Date Formats

DB_Newbie2007 wrote:
Does anyone know of a method to try and convert dates into a us-english format?
Heh... I didn't until an hour or so ago. 🙂
This should help a bit. Don't...
--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)

February 13, 2021 at 4:02 am

#3844472
Reply To: Retrieve data from First 25 and last 25 data pages from the Database

Heh... might as well show that you're flexible, as well. Ask them if they want that in logical page order or physical page order. 😀
--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)

February 11, 2021 at 11:31 pm

#3844019
Reply To: Long running report- kill the session

khushbu wrote:
yea we are on it for improving /re designing.
Until then is there a way to identify the ask?
You will never fix it if you do such a thing. It...
--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)

February 11, 2021 at 10:26 pm

#3844004

Viewing 15 posts - 5,656 through 5,670 (of 59,089 total)