Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,481 through 9,495 (of 59,102 total)

Reply To: How to sum a number of rows with minute data where column format is datetime
This will do it for you. Details are in the comments.
```
-- DROP TABLE #MyTable
--===== Put the test data into a table.
     -- 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)
April 18, 2019 at 12:02 am

#3436031
Reply To: How to sum a number of rows with minute data where column format is datetime

caspersql wrote:
and sorry regarding
Jeff Moden wrote:
What format do you want the sum to be displayed as?
, I was able to figure out how to format the way 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)

April 17, 2019 at 6:03 pm

#3430065
Reply To: How to sum a number of rows with minute data where column format is datetime

caspersql wrote:
I'm working with a database where a column that includes duration in terms of minutes is stored as datetime. The data looks like this. Note the '1899-12-30' info can...
--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)

April 17, 2019 at 5:09 pm

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

Welcome back, Barry. Hope you're doing well. I still give credit to you for the term "Pseudo Cursor" all the time.
--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)

April 17, 2019 at 4:47 pm

#3428064
Reply To: Missing attachments

K. Thanks for the update, 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)

April 17, 2019 at 4:44 pm

#3428017
Reply To: Need to extend length of PK

jdasilva wrote:
The server is backed up regularly, but I don't want to have to bother that team if I can do things safely. I assume I would have to change...
--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)

April 15, 2019 at 10:25 pm

#3390390
Reply To: Contract Requirements

Lynn Pettis wrote:
I get a page not found error on the link above.
Me too.
--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)

April 15, 2019 at 6:42 pm

#3384837
Reply To: Need to extend length of PK

If they're not doing regular backups of your databases and transaction log files, you have a serious problem.
--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)

April 15, 2019 at 6:41 pm

#3384824
Reply To: Random DateTime Range

Please see the following article...
https://www.sqlservercentral.com/articles/generating-test-data-part-2-generating-sequential-and-random-dates
--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)

April 15, 2019 at 6:38 pm

#3384767
Reply To: Difficulty deciding which job to take

Next step to consider... these two jobs aren't the only two jobs in this world.
--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)

April 15, 2019 at 6:15 pm

#3384127
Reply To: Today's Random Word!

Ed Wagner wrote:
Bar
Setting
--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)

April 15, 2019 at 3:14 pm

#3377578
Reply To: Good sources for SQL training?

The most important step is to have a learning/test/experimentation environment you have all to yourself. The following link contains a "download" button that will provide you with a free copy...
--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)

April 14, 2019 at 6:01 pm

#3336906
Reply To: A single query to display the result of multiple date selection in month columns

These report periods can overlap; a fiscal quarter will be contained in the range of its fiscal year. I like the MySQL convention of using double zeroes for months 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)

April 14, 2019 at 4:37 pm

#3334453
Reply To: Difficulty deciding which job to take

The words that strike me here is ...
I have a good job, but have been offered one from a company i once worked for
The first step is to sit down...
--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)

April 14, 2019 at 4:28 pm

#3334320
Reply To: Why a query would pick unrelated index

S_Kumar_S wrote:
Hi I came across a scenario where a query is picking totally unrelated index in the execution plan. Here is the case: SELECT A.tranid,A.transittime FROM table1 A WITH(nolock) JOIN...
--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)

April 14, 2019 at 3:54 pm

#3333659

Viewing 15 posts - 9,481 through 9,495 (of 59,102 total)