Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,181 through 3,195 (of 59,086 total)

Reply To: Calendar table in SQL

Here's another listing that not only lists the fixed holidays that always occur on the same day of every year but also how to calculate the "movable" holidays.
https://en.wikipedia.org/wiki/Public_holidays_in_Portugal
Here's one...
--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)

July 15, 2022 at 3:54 pm

#4063881
Reply To: how to call a scalar function without schema in sqlserver 2019

Johan Bijnens wrote:
By now, you know the solution.
Want to make it even better, do not use a SCALAR value function, but turn it into a (in-line)Table valued function ! In most...
--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)

July 15, 2022 at 3:44 pm

#4063877
Reply To: Which Error

The correct answer should have been... find the person that wrote the trigger with an empty CATCH and have a nice pork chop dinner with them. 😀
--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)

July 15, 2022 at 3:29 pm

#4063848
Reply To: Which Work Is Suited for In-Person?

From the Aritcle:
What work is suited for live, in-person interaction? Which aspects of your job benefit from seeing others face-to-face?
BWAAA-HAAA-HAAA!!! I can think of no thing that would prove...
--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)

July 15, 2022 at 3:23 pm

#4063847
Reply To: Parsing a lange XML data-column from one server to another

Jonathan AC Roberts wrote:
Can you just create a linked server in SSMS, then just do an "insert into select * from" command in SSMS?
If you cannot create a linked server then, if...
--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)

July 15, 2022 at 3:14 pm

#4063846
Reply To: Left Join with reference data.

My question would be, why are you using two tables to do one thing? It looks to me like it should be a single table because there appears to 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)

July 15, 2022 at 3:02 pm

#4063845
Reply To: Parsing a lange XML data-column from one server to another

kaj wrote:
Even though the MS documentation states that literals longer than 4000 characters are cast as NVARCHAR(MAX) this doesn't seem to be the case.
Constants (Transact-SQL) - SQL Server |...
--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)

July 15, 2022 at 4:08 am

#4063620
Reply To: Cost of Transactional Replication at the Publisher

I've searched for a more recent document that mentions performance in terms of overhead percentages but found none. I wouldn't expect to see such a thing from future MS documentation...
--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)

July 14, 2022 at 5:08 pm

#4063428
Reply To: Parsing a lange XML data-column from one server to another

gkramer 23701 wrote:
Write-output from the PS script:
INSERT INTO XML_REPORT_ALL ( logdate, Report, runnum, servername ) VALUES ( '07/11/2022 11:43:12','<LOG><ALG><ROW><CUSTOMER>... many more info here..... TYPE><','5','COURSE-SQLSERVER' )
I guess I'll never understand why people...
--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)

July 14, 2022 at 4:58 pm

#4063398
Reply To: Does the order of where clauses matter?

To add to what ratbak and Grant have stated, the other thing that paying attention to the order of the criteria in the WHERE helps with troubleshooting. Yeah... I know...
--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)

July 14, 2022 at 4:31 pm

#4063388
Reply To: how to call a scalar function without schema in sqlserver 2019

ratbak wrote:
No: "Scalar functions must be invoked by using at least the two-part name of the function (<schema>.<function>)"
Why are you even trying to work around this? You should preface...
--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)

July 14, 2022 at 4:23 pm

#4063382
Reply To: How to Find the Start and End Dates for the Current Week (and more)

@thisisfutile
I'm truly humbled by your thoughtful comments and the references to a couple of articles. I really appreciate the feedback and... I'm glad I could make you laugh! 😀 I'm...
--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)

July 14, 2022 at 3:57 pm

#4063371
Reply To: While Loop Data Issue

mcfarlandparkway wrote:
How to loop the data based on start and end dates below?
Declare @StartDate Datetime Declare @EndDate Datetime
Select @StartDate = '20220611' SET @EndDate = GETDATE()
WHILE @StartDate < = @EndDate BEGIN...
--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)

July 14, 2022 at 3:45 pm

#4063367
Reply To: Please help to get, Alphabet with underscore i.e special charecter

Thanks for the feedback 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)

July 14, 2022 at 3:23 pm

#4063334
Reply To: How to get last 5 weeks start and end dates

@mcfarlandparkway
Did that work for 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)

July 14, 2022 at 3:22 pm

#4063333

Viewing 15 posts - 3,181 through 3,195 (of 59,086 total)