Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 59,086 total)

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
Reply To: Help with Pivoting Table

First, really nice job on providing "Readily Consumable Data" AND it actually works without error! 😀
With respect to the output you posted, are you looking to pivot ONLY those rows...
--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 5:59 pm

#4058210
Reply To: Help Transposing SQL Table Pt3

Not to worry, Carlton. They don't delete questions on this site except for SPAM. Thanks for the feedback.
The "pivoting" thing is actually pretty easy. In the old days, it was...
--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 5:48 pm

#4058208
Reply To: Help Transposing SQL Table Pt3

None of the data between the two graphics matches each other nor does the test data. You need to be more clear and explain things like the other 4 statuses...
--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 2, 2022 at 11:31 pm

#4058016
Reply To: what minimum permission i should give to new login , new user and new schema.

Like I said, I've never had to do such a thing as that requested but... I believe that the user of a schema can create objects and that's 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)

July 2, 2022 at 4:06 am

#4057808
Reply To: Cumulative count distinct for a period of 3 months

If you want to play with something more substantial, here's a 10 million row table to play with, complete with expected indexes. Don't let the 10 million rows scare anyone. ...
--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 2, 2022 at 3:28 am

#4057798
Reply To: Cumulative count distinct for a period of 3 months
~~Not sure how you figure the total for Jan, Feb, Mar 2022 is 11. There are 4 in Jan, 5 in Feb, and 4 in Mar. 4+5=9 + 4 =...~~
- This reply was modified 4 years, 1 months ago by Jeff Moden. Reason: Finally realized my mistake
--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 1, 2022 at 10:27 pm

#4057740

Viewing 15 posts - 3,241 through 3,255 (of 59,086 total)