Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,931 through 3,945 (of 59,067 total)

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

Ah, there you are. The forum had a probem with email notifications that they just fixed in the last 2 days and I couldn't find this thread. I'll go back...
--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 8, 2022 at 8:58 pm

#3981391
Reply To: group records by week

Just curious... I might have missed it in the now 4 pages of post but how many rows per day are you looking to do this 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)

February 8, 2022 at 8:52 pm

#3981389
Reply To: Requirements doc and interviewing development groups

Jason Wilks wrote:
We are trying to get requirements from the development group who has just started programming. We are creating a spreadsheet to send out to all of the dev groups...
--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 8, 2022 at 8:33 pm

#3981385
Reply To: group records by week

Bruin wrote:
I'm not opposed to xp_cmdshell, and was wanting the csv files to be pipe(|) delimited. These 3 files will be used in a P/S import process to SQL as...
--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 8, 2022 at 8:24 pm

#3981381
Reply To: group records by week

Bruin wrote:
It started with grouping records by week to see the amount of data, and once I saw that I needed it to break down by day in 8 hour...
--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 7, 2022 at 8:41 pm

#3981191
Reply To: Speedy Break Fix

Steve Jones - SSC Editor wrote:
David.Poole wrote:
I think the important thing is to reflect on the lessons learned and ask what we would do better with the benefit of hindsight.
... The point is these...
--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 7, 2022 at 8:20 pm

#3981190
Reply To: group records by week

Heh... wow... this post sure has taken a turn. What ever happened to "Get records by week"?
--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 7, 2022 at 7:44 pm

#3981186
Reply To: Store invoke-sqlcmd result in PowerShell variable and use it for comparison

I'll add to that... look at what you're doing... You're writing T-SQL in PowerShell to do backups? Just write a stored procedure and then you don't have to worry about...
--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 7, 2022 at 7:39 pm

#3981185
Reply To: Comparing nvarchar with string has started generating weird conversion error

shaunos wrote:
In fairness, as I mentioned before, these files have been fine for years except for this month but yes we will have to add some more defensive checks 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 7, 2022 at 7:34 pm

#3981184
Reply To: Accessing variables dynamically

Pete Bishop wrote:
Any ideas?
Yep, but no one using SSIS seems to like it. Why not just use stored procedures without SSIS?
--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 7, 2022 at 7:29 pm

#3981183
Reply To: Store invoke-sqlcmd result in PowerShell variable and use it for comparison

I can't help here but I have to tell you that putting passwords into clear text is a really bad idea. They really need to be "trusted" connections based on...
--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 6, 2022 at 9:01 pm

#3980987
Reply To: SSIS SFTP using WinSCP

Ah, got it. Thank you. Heh.... yep. Been there and done that myself.
--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 6, 2022 at 8:57 pm

#3980986
Reply To: Comparing nvarchar with string has started generating weird conversion error

It always happens that way with such "no one made any changes" such things. 😀
It would be nice if you could post the actual code you're talking about so we...
--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 6, 2022 at 5:18 pm

#3980977
Reply To: SSIS SFTP using WinSCP

water490 wrote:
i figured out the issue. ignore post.
Two way street here... Can you tell us, please?
--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 6, 2022 at 3:54 pm

#3980966
Reply To: Comparing nvarchar with string has started generating weird conversion error

shaunos wrote:
Has anyone seen anything behaviour like this before?
Yes... and every time someone claims that something has been running for years and no one has made a change, someone has...
--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 6, 2022 at 2:52 pm

#3980963

Viewing 15 posts - 3,931 through 3,945 (of 59,067 total)