Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,306 through 4,320 (of 59,069 total)

Reply To: Loading x number of CSV files into x number of unique tables of a database

Discounting the Excel thing for now, a little work in T-SQL will allow you to read the row header from each file, figure what's there, and assign it to 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)

November 22, 2021 at 3:49 am

#3955422
Reply To: Grouping , time difference in minutes

gjoelson 29755 wrote:
Jeff,
I added sample data above related to the duplicate record, let me know if what I gave here is ok.
- Thanks.
The table is missing the 6th column. So is...
--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)

November 22, 2021 at 2:31 am

#3955410
Reply To: Are there any read-made example databases I can use for a new Azure SQL Database?

Grant Fritchey wrote:
Yep. AdventureWorks in all it's messed up glory. Honestly, I love that sample database. Why? Because it looks like all the other messed up constructs I see everywhere else....
--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)

November 18, 2021 at 8:26 pm

#3954597
Reply To: Automate Import Process

That's OK. It's the tool that will allow you to do things like run the CLI of a program from SQL Server. Such a thing can also be done using...
--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)

November 18, 2021 at 3:31 am

#3954282
Reply To: bring back single line

Bruin wrote:
Thanks that helped me find a solution.
Awesome. Thank you for the feedback!
--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)

November 18, 2021 at 3:23 am

#3954281
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

I doubt it. The still haven't made a built in sequence generator even though I've added to Erland Sommarskogs "Connection" post that he created more than a decade ago (going...
--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)

November 17, 2021 at 7:16 pm

#3954178
Reply To: Automate Import Process

water490 wrote:
I am using Filezilla. Yes it can be operated via command line
Perfect. The next question is, which is a showstopper for a whole lot of people (even though 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)

November 17, 2021 at 7:12 pm

#3954177
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

I saw that and was totally impressed. It only took them 5 years to get a fix out... kind of. As you say, it's only in Azure so far. 😀
Once...
--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)

November 17, 2021 at 6:28 pm

#3954160
Reply To: Automate Import Process

water490 wrote:
Here is the plan:
-log into SFTP server and download files to local directory
-unzip files to specified folder
-import files into SQL Server table (it will always be the same table)
-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)

November 17, 2021 at 3:07 am

#3953845
Reply To: How to distinguish human principals from all the rest in sys.server_principals ?

Mr. Brian Gale wrote:
type = 'U' means you are grabbing all "user" type of login. To SQL, a "human" and a "non-human" are identical. It is just a login.
How would SQL 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)

November 16, 2021 at 6:33 am

#3953448
Reply To: Automate Import Process

You're posting in an SQL Server 2019 forum. BULK INSERT and BCP have both had "CSV" capabilities since SQL Server 2017. If the files and the tables are consistent, there'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)

November 16, 2021 at 6:29 am

#3953447
Reply To: Show Queries

Grant Fritchey wrote:
Jeff Moden wrote:
water490 wrote:
Thank you everyone. I have been saving the files to a folder. it works for me because I only have a few queries. I am so used...
--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)

November 16, 2021 at 6:17 am

#3953444
Reply To: Summit Reflections

mfagan12 wrote:
I don't feel comfortable flying normally but with Covid--even though I just got my booster and wear a mask everywhere--the thought of being on a crowded plane. ....
--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)

November 15, 2021 at 8:09 pm

#3953305
Reply To: Show Queries

water490 wrote:
Thank you everyone. I have been saving the files to a folder. it works for me because I only have a few queries. I am so used to Access...
--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)

November 15, 2021 at 7:56 pm

#3953300
Reply To: Great Writers Get Hired

Rod at work wrote:
Jeff Moden wrote:
I have to tell you that if you work with the right recruiter, you don't have to worry about AI HR bots, HR people, or whatever. A lot...
--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)

November 15, 2021 at 7:52 pm

#3953298

Viewing 15 posts - 4,306 through 4,320 (of 59,069 total)