Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,491 through 11,505 (of 59,099 total)

RE: updating records from a staging table while converting and removing trailing or leading spaces

NewBornDBA2017 - Friday, August 17, 2018 8:33 AM
Done
update [Staging].[StgContactdata]
set CompanyNid = REPLACE(CompanyNid, char(9),'')
update [PMG].[Contactdata]
set CompanyNids = convert(int,s.CompanyNid)
FROM [PMG].[Contactdata]...
--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)

August 17, 2018 at 8:55 am

#2002269
RE: Long Formats

Steve Jones - SSC Editor - Friday, August 17, 2018 8:10 AM
Jeff Moden - Friday, August 17,...
--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)

August 17, 2018 at 8:38 am

#2002262
RE: Using UPDATE()

TomThomson - Friday, August 17, 2018 8:11 AM
Jeff Moden - Friday, August 17, 2018 7:42 AM
--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)

August 17, 2018 at 8:36 am

#2002261
RE: Using UPDATE()

Heh... this will make a good, quick ice-breaker question for interviews like the "How do you get the current date and time in T-SQL". Litmus strips 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)

August 17, 2018 at 7:42 am

#2002234
RE: Long Formats

My answer would be ... don't do this in R. 😀 It's simple to do in T-SQL. And it's funny a bit... you've nicely covered up the word "EAV" with...
--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)

August 17, 2018 at 7:36 am

#2002231
RE: Huge number of tables

aaron.reese - Friday, August 17, 2018 6:20 AM
and I expect in any given installation 50K of them are empty 🙂
Except on Tuesdays....
--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)

August 17, 2018 at 6:48 am

#2002217
RE: How to a use a temp table as a destination for a dataflow in SSIS

andycadley - Thursday, August 16, 2018 1:15 PM
For what it's worth, the "right to forget" in the GDPR does not apply 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)

August 17, 2018 at 6:31 am

#2002215
RE: How to a use a temp table as a destination for a dataflow in SSIS

Shifting gears on all of this a bit... the "lesser" site (the one that does NOT have the forgotten data) should not be doing the data "pull", IMHO. To be...
--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)

August 16, 2018 at 9:52 pm

#2002179
RE: How to a use a temp table as a destination for a dataflow in SSIS

FunkyDexter - Thursday, August 16, 2018 11:14 AM
Blimey, loads of stuff to respond to. Thanks for all the input folks.
A bit 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)

August 16, 2018 at 9:49 pm

#2002178
RE: How to a use a temp table as a destination for a dataflow in SSIS

Thom A - Thursday, August 16, 2018 9:21 AM
You could, if you wanted, create the table in tempdb. Although it's not 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)

August 16, 2018 at 9:29 am

#2002099
RE: How to a use a temp table as a destination for a dataflow in SSIS

FunkyDexter - Thursday, August 16, 2018 8:08 AM
So can I use a temp table in this way?
You can if you do...
--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)

August 16, 2018 at 8:53 am

#2002091
RE: Are the posted questions getting worse?

jonathan.crawford - Thursday, August 16, 2018 8:18 AM
In "Lives Of A Cell", Lewis Thomas postulates that Language is really...
--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)

August 16, 2018 at 8:28 am

#2002079
RE: Why QUOTENAME is important

RonKyle - Thursday, August 16, 2018 7:33 AM
Jeff Moden - Thursday, August 16, 2018 7:06 AM
--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)

August 16, 2018 at 8:21 am

#2002077
RE: Why QUOTENAME is important

RonKyle - Thursday, August 16, 2018 6:33 AM
This also applies to Jeff's comments. The original comment said a simple check...
--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)

August 16, 2018 at 7:06 am

#2002053
RE: Are the posted questions getting worse?

JustMarie - Tuesday, August 14, 2018 1:59 PM
And this is why I drink....
Four months ago I told my boss that I need...
--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)

August 16, 2018 at 6:38 am

#2002042

Viewing 15 posts - 11,491 through 11,505 (of 59,099 total)