Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,901 through 6,915 (of 59,102 total)

Reply To: Calculating Previous and Next Week

It's not really a useful thing... there are 14 different "week" patterns (one for each day of the week times 2 because of leap years) and there's the issue 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)

June 18, 2020 at 5:23 pm

#3764227
Reply To: T-sql Syntax help needed

MiraAniston wrote:
I tried and it didn’t work for me either. Maybe you have some other solutions? Thanks
Saying something as nebulous as "it didn't work" without telling us WHAT about 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)

June 18, 2020 at 4:54 pm

#3764220
Reply To: SSMS: How to save multiple resultsets from same query into 1 result or 1 file?

VoldemarG wrote:
I am submitting an official request for DBA of certain servers to run a script on those servers and give me back the resultset.
However the script (the actual script...
--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 18, 2020 at 4:06 pm

#3764203
Reply To: How to do User Defined Function take input as text and output text and numbers ?

The MS documentation is meant to be a reference rather than a "how to use" tutorial. The key to the problem on this post is to "find the first non-numeric...
--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 18, 2020 at 3:34 pm

#3764190
Reply To: Ignoring error and continue

Phil Parkin wrote:
And the problem with your question is that you did not give me the full picture.
Now you are drip-feeding clues into the thread as they come up, which is...
--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 18, 2020 at 5:07 am

#3764090
Reply To: How to do User Defined Function take input as text and output text and numbers ?

If the data is that consistent (some decimal value followed by character values with no spaces), no loops required, UDF scalars, or other forms of RBAR required. Just go for...
--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 18, 2020 at 3:19 am

#3764074
Reply To: All info about all Extended Events on the server - how can i get it via a query?

I think that one of the best answers (other than, of course, "It Depends) comes in the form of a suite of tools by Mr. Brent Ozar. I just refer...
--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 18, 2020 at 2:08 am

#3764067
Reply To: Two Strings compare using t-sql

schleep wrote:
Wow. So simple now.
Still labouring in 2008, our next version is supposed to be 2016, with no set date for that.
I figure I'll be able to start using STRING_AGG...
--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 17, 2020 at 8:03 pm

#3763989
Reply To: Script specific stored procedures

Either that or look into sys.SQL_Modules, which is a system object that comes with SQL Server and can be interrogated using T-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)

June 17, 2020 at 6:03 pm

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

jasona.work wrote:
Eirikur Eiriksson wrote:
jasona.work wrote:
And now, how to put the brakes on a migration project...
Break your wrist on a bicycle ride so you only have one hand to type with 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 17, 2020 at 5:50 pm

#3763956
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

VoldemarG wrote:
Quick question: Why/for what benefit(S) should I do this?
2. After building the stored procedure, you need to run the following code to convert it into a "system" stored
procedure 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)

June 17, 2020 at 5:47 pm

#3763954
Reply To: SQL Server Fragmentation- Defragment

Mr. Brian Gale wrote:
That being said, I run SQL 2016 standard so have not had the chance to play with partitions, so someone with more experience in partitions can probably 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)

June 17, 2020 at 7:24 am

#3763785
Reply To: I Read Quite a Bit

Grant Fritchey wrote:
Jeff Moden wrote:
From the Article...
Yet, all the responses were either blatantly wrong, or answering different questions.
Heh... this happens during meetings, as well. Someone goes off on a tangent or with...
--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 16, 2020 at 3:17 pm

#3763501
Reply To: adding a Select statement to an existing table

atulyan.aries wrote:
no tools
Ok then... let's reword the question... how are you producing the scripts that you cite in your original post?
--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 15, 2020 at 10:37 pm

#3763312
Reply To: ISNULL clause with a condition

Erland Sommarskog wrote:
Jeff Moden wrote:
If this is being used in the SELECT list of a query,
Jeff, if that is part of a SELECT list, what SQL dialect would that be?...
--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 15, 2020 at 10:34 pm

#3763311

Viewing 15 posts - 6,901 through 6,915 (of 59,102 total)