Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,756 through 10,770 (of 59,095 total)

RE: DT_BYTE to DT_DBDATE

Please post a handful of the "0x" values from the table you loaded those DT_BYTE values into so we can have a look.
--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)

October 31, 2018 at 4:01 pm

#2011972
RE: Skills for Everyone in Tech

patrickmcginnis59 10839 - Wednesday, October 31, 2018 12:37 PM
Jeff Moden - Tuesday, October 30, 2018 8:38 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)

October 31, 2018 at 1:07 pm

#2011939
RE: Computed Column Specification formula

w.bartelink - Wednesday, October 31, 2018 12:28 PM
sgmunson - Wednesday, October 31, 2018 10:15 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)

October 31, 2018 at 12:59 pm

#2011938
RE: Exponential values conversion

Eirikur Eiriksson - Wednesday, October 31, 2018 8:01 AM
Jeff Moden - Wednesday, October 31, 2018 7:44 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)

October 31, 2018 at 8:03 am

#2011849
RE: Full Backup Files - Fastest Way to Copy Over WAN

dajonx - Wednesday, October 31, 2018 7:12 AM
Thank you for all of the responses!
We do have Riverbed CX5070 appliances at both sites. ...
--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)

October 31, 2018 at 7:50 am

#2011842
RE: Exponential values conversion

pwalter83 - Wednesday, October 31, 2018 5:15 AM
Eirikur Eiriksson - Wednesday, October 31, 2018 4:44 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)

October 31, 2018 at 6:25 am

#2011822
RE: Changing 1 or + in a telephone number to the correct format

saravanatn - Wednesday, October 31, 2018 1:34 AM
Jeff Moden - Monday, October 29, 2018 6:51 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)

October 31, 2018 at 6:09 am

#2011820
RE: seperate data in 1 row

Lynn Pettis - Tuesday, October 30, 2018 10:36 PM
Jeff Moden - Tuesday, October 30, 2018 6:20 PM
--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)

October 31, 2018 at 6:06 am

#2011819
RE: Full Backup Files - Fastest Way to Copy Over WAN

dajonx - Tuesday, October 30, 2018 9:28 AM
Hi,
I am trying to Robocopy large .bak files over the WAN and it's going terribly...
--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)

October 30, 2018 at 7:59 pm

#2011787
RE: seperate data in 1 row

Ya just gotta wonder if all those CASEd LIKEs are slower than just doing unconditional REPLACEs with the right collation.
p.s. Apparently the version of SQLPrompt you used doesn't...
--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)

October 30, 2018 at 6:20 pm

#2011784
RE: Skills for Everyone in Tech

drew.allen - Tuesday, October 30, 2018 8:08 AM
Jeff Moden - Tuesday, October 30, 2018 8:01 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)

October 30, 2018 at 8:38 am

#2011703
RE: seperate data in 1 row

Thanks for your code but can you please do as I asked and provide the sample data in a readily consumable format as I did in my example? If you...
--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)

October 30, 2018 at 8:36 am

#2011701
RE: seperate data in 1 row

If you want to stop going back and forth with incremental questions, please take the time to post the code to create a table and populate it as I did...
--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)

October 30, 2018 at 8:18 am

#2011693
RE: seperate data in 1 row

Krasavita - Tuesday, October 30, 2018 7:09 AM
I found problem in email it goes like that:'%@rs.org
%'
eamplee:
( N'ba@rs.org
julia.leis@rs.org' )
how can this 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)

October 30, 2018 at 8:16 am

#2011691
RE: Skills for Everyone in Tech

drew.allen - Tuesday, October 30, 2018 7:41 AM
Jeff Moden - Tuesday, October 30, 2018 6:39 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)

October 30, 2018 at 8:01 am

#2011686

Viewing 15 posts - 10,756 through 10,770 (of 59,095 total)