Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,551 through 5,565 (of 59,089 total)

Reply To: Newb - SQL Server IIF() Function

Kristen-173977 wrote:
Jeff Moden wrote:
COALESCE has a nasty quirk, as well. You know what it is... it uses whatever the highest precedence datatype there is in the operands. ISNULL doesn't have 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)

March 3, 2021 at 1:16 am

#3852588
Reply To: Name of the remote server in a query

VoldemarG wrote:
by the way, since we already have touched the subject,
is it a good idea at all to execute anything like this on a remote server as EXEC (...) AT...
--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 8:16 pm

#3852467
Reply To: pivot on 2 fields

It would have been much more neighborly of you if you had read the article at the link I directed you to and provided the data in a "readily consumable"...
--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 8:06 pm

#3852465
Reply To: Name of the remote server in a query

Ram wrote:
Haa. How did I miss it? Such a simple solution!
Curious... which solution?
--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 7:28 pm

#3852424
Reply To: DelimitedSplit8K License Question

Bartoletti wrote:
I agree entirely, but this blog was intended to focus purely on the relative performance of XML Lists, because the comments about their poor performance when used as parameters...
--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 6:06 pm

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

jcelko212 32090 wrote:
As a guy who constantly advocates for ANSI/ISO standards, I would like to point out that the CONCAT is not SQL but local dialect. The correct syntax is in...
--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 6:02 pm

#3852383
Reply To: Name of the remote server in a query

I'm thinking that you've changed the purpose of the code. The first query in the code uses the 3 part naming convention and seems to be meant to look at...
--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 1:23 am

#3851995
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

Viewing 15 posts - 5,551 through 5,565 (of 59,089 total)