Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,536 through 5,550 (of 59,072 total)

Reply To: Name of the remote server in a query

I guess I'm a little confused... You already know the remote server name or you wouldn't be able to query its' msdb database. Why not just substitute a literal 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)

March 2, 2021 at 12:34 am

#3851990
Reply To: Logic is not wokring

It's been a while since I've messed with negative boolean algebra so I hope I got this right...
The first one equates to NOT (invoice_cl = 'INN1' OR PaymentStatus = 'Unpaid'). ...
--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)

March 2, 2021 at 12:26 am

#3851972
Reply To: Newb - SQL Server IIF() Function

I have to disagree a bit on hating "ordering" in an RDBMS... indexes would simply be of no use without "ordering". The "order" of things is quite critical in RDBMS's...
--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)

March 1, 2021 at 11:59 pm

#3851962
Reply To: What's a Lot of Money?

Heh... "What a lot of money"? It's the same question as "What's big data"? It's something that you've not had to handle before. 😀
--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)

March 1, 2021 at 11:51 pm

#3851961
Reply To: pivot on 2 fields

Bruin wrote:
I want to show current year and previous.. do you have any examples based upon my current query?
Thanks again...
I'm pretty confused about what you're actually using for a source...
--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)

March 1, 2021 at 11:32 pm

#3851956
Reply To: Newb - SQL Server IIF() Function

ScottPletcher wrote:
ISNULL has some bad quirks that can cause problems, although I admit I still use it at times, simply out of habit, although I never embed it (also, btw,...
--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)

March 1, 2021 at 11:05 pm

#3851955
Reply To: Viva

Heh... MS should be sued for false advertising when it comes to their videos. 😉
--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)

March 1, 2021 at 6:14 pm

#3851838
Reply To: pivot on 2 fields

Bruin wrote:
I was trying to get the days so they would be dynamic rather than having to hard those each month.. I also wanted the channel to be sub-category 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)

March 1, 2021 at 6:05 pm

#3851836
Reply To: The Future Synonym

To me, it's a bit funny that someone would say that they're "less reliable" than views... they are one of the few things that operate precisely the way they're documented...
--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)

March 1, 2021 at 3:25 pm

#3851762
Reply To: Common Table Expression Misunderstandings

f.clems wrote:
jcelko212 32090 wrote:
The name common table expression comes from the way that you factor it out of multiple positions in a query expression and move it to the front. By...
--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)

March 1, 2021 at 3:19 pm

#3851761
Reply To: Common Table Expression Misunderstandings
dweil56 wrote:
Any thoughts on the pluses or minuses of using a temporary table versus a CTE? Would the size of the "virtual view" be a consideration.
Sure...
1. Like what was written...
--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 28, 2021 at 6:16 pm

#3851365
Reply To: Common Table Expression Misunderstandings

jcelko212 32090 wrote:
The name common table expression comes from the way that you factor it out of multiple positions in a query expression and move it to the front. By analogy,...
--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 28, 2021 at 4:51 pm

#3851349
Reply To: Common Table Expression Misunderstandings

f.clems wrote:
Jeff Moden wrote:
BWAAAA-HAAAAA! 😀 Let's not because then someone would want to rename iTVFs as PDIVs (Parameter Driven Inline Views). 😀
(THUMBS-UP) If it helps to leave the misconception behind,...
--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 28, 2021 at 4:47 pm

#3851348
Reply To: Common Table Expression Misunderstandings

f.clems wrote:
With such a name, CTE were kind of made for misconceptions. Could we rename them LVR (Local View with Recursion)?

BWAAAA-HAAAAA! 😀 Let's not because then someone would want to...
--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 28, 2021 at 12:59 pm

#3851304
Reply To: Remove Carriage Returns / Line Breaks / Any other reason the "text" moves down

DCL wrote:
Thank you for the reply. I tried that and the values in the original column are still the same. Should that have output to a new column? I created...
--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 28, 2021 at 12:52 pm

#3851302

Viewing 15 posts - 5,536 through 5,550 (of 59,072 total)