Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,771 through 7,785 (of 59,072 total)

Reply To: Modify Data to Add a Letter Before Numbers

uknites wrote:
I was trying to copy the data from one column to another and then add X in front of it
Thanks a lot 🙂
I managed to do it with your...
--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, 2020 at 7:11 pm

#3724036
Reply To: Help with query

Yes, the OP should be doing that but you also presumed that the OP knows how to convert the data to a normalized form. In order for the OP 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, 2020 at 4:31 pm

#3723991
Reply To: Parallel Load thousands csv Files

Ah... finally found this post again. Like I said on my last, is there any chance at of of you attaching the first 10 or so line of one 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)

February 7, 2020 at 6:45 am

#3723837
Reply To: Help with query

jcelko212 32090 wrote:
>>
SELECT rm_id FROM Foobar
EXCEPT
SELECT rm_id FROM Vague_Relationships;
Since I DID provide the DDL and a substantial amount of readily-consumable data for anyone (including you) to test with, you should get...
--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, 2020 at 5:54 am

#3723827
Reply To: Help with query

Here's some test data... You'll need to build the fnTally function that I have a link for in my signature line below unless you already have one of your own.
--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, 2020 at 5:25 am

#3723491
Reply To: bcp error on NULL: "Unexpected EOF encountered in BCP data-file"

You BCP format file says that the delimiter for the end of the 1st field should start with a pipe and end with a quote. It doesn't for the 2nd...

--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, 2020 at 12:39 am

#3723481
Reply To: STUFF Function use

Steve Collins wrote:

Ha it's the exact same query.

I left out "TYPE" because it was guaranteed to be integer digits and "TYPE" makes things a bit slower over the long haul but,...

--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 5, 2020 at 7:39 pm

#3723428
Reply To: How can we ensure whether database is migrated successfull from DBA Side

To the best of my knowledge, no such scripts exist.

--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 5, 2020 at 2:11 pm

#3723294
Reply To: High CPU utilization due to too much idle sessions on DB instance.

Check to see if the connections being made are using M.A.R.S (Multiple Active Result Sets). Connections are supposed to default to this being off but several of us have found...

--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 5, 2020 at 2:09 pm

#3723293
Reply To: STUFF Function use

Please help us help you... in the future, please post readily consumable data. Please Read'n'Heed the article at the first link for how to help us help you more quickly...

--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 5, 2020 at 2:04 pm

#3723292
Reply To: Conversion Error When Using CASE Statement

Jason A. Long wrote:

Jeffrey Williams wrote:

You should add the money data type to this - it shows that ISNUMERIC recognizes money formats and will convert those correctly.

I did. The 3rd value has a...

--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 4, 2020 at 11:47 pm

#3723135
Reply To: SpinOff: Recruitment Question

Jeffery Williams wrote:

oogibah You have GOT to be kidding me.

Are you saying that you ran into a SQL dev that could not produce the current date/time let alone datepart?

#Scary

AND A DBA...

--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 4, 2020 at 11:34 pm

#3723133
Reply To: Bulk loading data using For Loop container with variable number

JimReeves71 wrote:

Hi there

I am developing an SSIS package to bulk load data. Now the data can be high in volume (300,000 to 2 million records)

What i want to design 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)

February 4, 2020 at 11:31 pm

#3723132
Reply To: Conversion Error When Using CASE Statement

It'll also say that ',,,,,,,,,,,' is a valid numeric. And the cool part about converting to MONEY during imports (if you don't need more than 4 decimal places) is 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)

February 4, 2020 at 11:13 pm

#3723128
Reply To: Scientific number in varchar column

MVDBA (Mike Vessey) wrote:

x wrote:

MVDBA (Mike Vessey) wrote:

Phil Parkin wrote:

MVDBA (Mike Vessey) wrote:

JEFF Do NOT go all SSIS on me 🙂 we all know it's Bulk insert with a formatfile or openrowset

Jeff's blood pressure just went up...

--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 4, 2020 at 2:41 am

#3722805

Viewing 15 posts - 7,771 through 7,785 (of 59,072 total)