Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,211 through 3,225 (of 59,067 total)

Reply To: Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)
ScottPletcher wrote:
Jonathan AC Roberts wrote:
ok, that's not what I thought you meant. I thought you meant flip all the bits.
This works for 0 and 1:
```
DECLARE @smallint smallint = 0
select...
```
--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 5, 2022 at 11:13 pm

#4059315
Reply To: Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)

What are the datatypes for the two columns in Question #1?
--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 5, 2022 at 10:32 pm

#4059295
Reply To: Removing UNION and getting the same result

Probably so he can get away from having to run two separate queries and then merge the results with a distinct UNION. That may or may not be faster, though. ...
--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 5, 2022 at 2:41 am

#4058876
Reply To: Do you dream about SQL Server and things IT?

skeleton567 wrote:
I wonder if it is because in our dreams our minds are more focused on one thing at a time and it is easier without so many distractions.
I would...
--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 5, 2022 at 2:39 am

#4058875
Reply To: Working with T-SQL function AVG ()

Guy Stephens wrote:
Perhaps more important than the DISTINCT keyword is the AVG() function's handling of NULL values.
NULLs behave similarly to DISTINCT - regardless of how AVG() is called. That is, the...
--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 4, 2022 at 5:52 pm

#4058573
Reply To: Removing UNION and getting the same result

Heh... there is an EXCEPT, though... same "class" of method.
--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 4, 2022 at 5:09 pm

#4058571
Reply To: How to send data from table to text file by date

Just in case you're still around, the reason I'm asking is because, if the ultimate use is to import the data into another SQL Server, using BCP Out in the...
--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 4, 2022 at 4:54 pm

#4058551
Reply To: Employee Hierarchy Recursive CTE Different Top Level Directors Overtime

In other words, please read and heed the article at the first link in my signature line below for one of many methods to provide some "Readily Consumable Test Data"...
--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 4, 2022 at 3:54 pm

#4058545
Reply To: How to export SQL database tables into multiple XML Files?

Please go back and read the reply from Scott Pletcher and myself.
I agree that it sounds like you're trying to do a server to server transfer. With the exception 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)

July 4, 2022 at 3:48 pm

#4058543
Reply To: Removing UNION and getting the same result

It might be possible but I'm not going through the code to figure out which columns are coming from which tables. Using table aliases in all columns when joins are...
--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 4, 2022 at 3:39 pm

#4058542
Reply To: Performance problem

Thanks for the feedback on what it turned out to be, Jonas.
--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 4, 2022 at 3:33 pm

#4058541
Reply To: MS SQL Server 2012 question regarding SSIS

wrote:
I got this,...
What did you end up doing? I know this would help others in the future.
--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 4, 2022 at 3:27 pm

#4058530
Reply To: Help with Pivoting Table
Here's the query to cover your first request.
```
 SELECT  MontaguOwner                ...
```
--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 4, 2022 at 1:07 am

#4058291
Reply To: Help with Pivoting Table

carlton 84646 wrote:
Hi Jeff,
Using the same test data I provided I wonder if you could help me build on your code to achieve an additional outcome.
So, on the test data, 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)

July 3, 2022 at 10:21 pm

#4058261
Reply To: Help Transposing SQL Table Pt3

carlton 84646 wrote:
Jeff,
I'm going to have to be become very proficient with Pivot (CROSS TABS) with my company.
Thanks for the links
See my post on the other thread. I've also just updated...
--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 3, 2022 at 6:07 pm

#4058212

Viewing 15 posts - 3,211 through 3,225 (of 59,067 total)