Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,516 through 7,530 (of 59,072 total)

Reply To: Get the correct output

To Steve's good point...
From the posted input and the posted required output, it looks like there should only be a return if a given AlertID only has AlertTypeID's of both...
--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 19, 2020 at 6:19 pm

#3735667
Reply To: Question on BCP and Azure

I don't use Azure and I've not used VB in a million years. However, the following link seems to have a fair bit of info that you might find applicable...
--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 19, 2020 at 3:00 pm

#3735608
Reply To: SQL Is Always Going to be Popular

Oh... no question about trying something new being a good thing. That's actually how I got so involved with electronics, computers, and ultimately SQL Server (and many other programs including...
--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 19, 2020 at 1:37 pm

#3735598
Reply To: SQL Is Always Going to be Popular

I don't know... if you consider that 100 hours is probably outside of your normal work hours and you spend 2 hours of the 100 every day on weekdays, 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 18, 2020 at 11:38 pm

#3735468
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
Her being home isn't helping because she's also one of those folks that has to say everything she's doing out-loud as she's doing it. It's as bad...
--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 18, 2020 at 5:24 pm

#3735403
Reply To: Are the posted questions getting worse?

Phil Parkin wrote:
Jeff, these may be for you (if you dare venture anywhere to buy them, that is!). I have a pair and they work a treat. Not that 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)

March 18, 2020 at 5:17 pm

#3735400
Reply To: SQL Is Always Going to be Popular

Heh... I'm often told that SQL Server isn't the center of the Universe. My standard reply is "Cool! Let's turn it off and see if you're right!". 😀
Oddly enough, they...
--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 18, 2020 at 5:02 pm

#3735398
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
We closed our office last week, everyone at home. Not a big change for some of us, but it is a change. Many things are less active and 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)

March 18, 2020 at 4:36 pm

#3735394
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
I'm glad my wife isn't on this thread...
I'll bet she is too! 😀
--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 17, 2020 at 9:05 pm

#3735152
Reply To: extract all data with week

I appreciate your humility, Phil, but I think Kruger-Dunning is in effect and you're drastically underrating your skills both in SSIS and as a writer.
--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 17, 2020 at 3:53 pm

#3735066
Reply To: WITH Query definition not working

SQL Galaxy wrote:
Yeah, I checked that first query. some servers all available drive retrieved and some servers not retrieved. could you suggest me what kind of permission required for fetching all...
--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 17, 2020 at 3:24 pm

#3735056
Reply To: extract all data with week

GaryV wrote:
If you don't understand these steps, I'd suggest finding a tutorial on SSIS that includes setting variables, ForEach and Connection Managers.
That's why I'm asking people to write a definitive...
--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 17, 2020 at 2:37 pm

#3735035
Reply To: Dynamically create and populate staging tables from CSV files

Stan Kulp-439977 wrote:
I would open the CSV file in Excel and search-and-replace the apostrophe with nothing, then save the revised file as a CSV file that now contains no apostrophes.
Apostrophes generally...
--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 17, 2020 at 12:23 am

#3734886
Reply To: need help with query having null value in end datate column is null

Jason A. Long wrote:
Jeff Moden wrote:
p.s. This is also why I default EndTime columns to '9999', which is the same as 9999-01-01. It means that I don't have to have an OR 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 16, 2020 at 9:13 pm

#3734860
Reply To: need help with query having null value in end datate column is null

Phil Parkin wrote:
Jeff, I think your bracket should be after 'AND', not before it.
Thanks for the catch, Phil. Corrected 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)

March 16, 2020 at 9:10 pm

#3734858

Viewing 15 posts - 7,516 through 7,530 (of 59,072 total)