Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,416 through 11,430 (of 59,095 total)

RE: Convert Varchar field

jcelko212 32090 - Friday, August 24, 2018 10:47 AM
Wouldn't it be a much better idea to get rid of these fractions,...
--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 24, 2018 at 12:03 pm

#2003259
RE: PIVOT

TJ_T - Thursday, August 23, 2018 4:58 PM
This would work if I knew all of the CarTypes, but I don't. Any ideas?
Yes......
--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 24, 2018 at 12:17 am

#2003148
RE: Count the Number of Weekend Days between Two Dates

@adam-2 Aspin,
Sorry, Adam... I do honestly appreciate anyone that will step up to bat with an article and share the knowledge they have and I thank you 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)

August 23, 2018 at 10:47 pm

#2003146
RE: Count the Number of Weekend Days between Two Dates

MartJ - Thursday, August 23, 2018 6:51 AM
I wrote a little blog post on something similar as an example of using 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 23, 2018 at 10:40 pm

#2003145
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, August 23, 2018 5:08 PM
Like it would last long enough us to notice. And...
--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 23, 2018 at 10:13 pm

#2003143
RE: Need help with renaming multiple tables

Jeff Moden - Thursday, August 23, 2018 10:09 PM
If you're going to use sp_rename to rename tables other than dbo (or whatever...
--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 23, 2018 at 10:10 pm

#2003142
RE: Need help with renaming multiple tables

If you're going to use sp_rename to rename tables other than dbo (or whatever your default schema is), you must specify the schema name in the first operand of sp_rename...
--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 23, 2018 at 10:09 pm

#2003141
RE: Count the Number of Weekend Days between Two Dates

carsten.saastamoinen - Thursday, August 23, 2018 9:54 AM
"Every bit helps avoid the "Death by 1,000 cuts" that so many systems experience. ...
--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 23, 2018 at 9:49 pm

#2003140
RE: Count the Number of Weekend Days between Two Dates

My very first article on this site was about how to find work days (week days, really... no holidays involved). Figured I'd update from that a bit to solve this...
--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 23, 2018 at 8:49 pm

#2003138
RE: Count the Number of Weekend Days between Two Dates

ScottPletcher - Thursday, August 23, 2018 4:24 PM
There's no need for any tally table nor recursion. A simple mathematical calc 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)

August 23, 2018 at 7:28 pm

#2003137
RE: Count the Number of Weekend Days between Two Dates

dbeggs57 - Thursday, August 23, 2018 6:01 PM
Jeff:
Thank you for correcting my code. This gives me something more to think 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)

August 23, 2018 at 7:17 pm

#2003136
RE: Count the Number of Weekend Days between Two Dates

dbeggs57 - Thursday, August 23, 2018 2:12 PM
Adam, thank you for your example, it got me thinking. I didn't have the table 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)

August 23, 2018 at 5:31 pm

#2003130
RE: Bullk insert in sql server..

Unless they've changed it recently, BULK INSERT and BCP are delimiter sensitive when it comes to counting rows rather than what humans perceive to be a line in a file. ...
--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 23, 2018 at 3:48 pm

#2003122
RE: PIVOT

TJ_T - Thursday, August 23, 2018 10:53 AM
I need help with SQL PIVOT
Example
SELECT Manufacturer, CarType
FROM Vehicles
Manufacture Cartype
Ford ...
--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 23, 2018 at 3:40 pm

#2003121
RE: Convert Varchar field

bpmosullivan - Wednesday, August 22, 2018 7:35 PM
I have a Varchar field with units in inches 🙁 that i need to convert...
--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 23, 2018 at 3:35 pm

#2003118

Viewing 15 posts - 11,416 through 11,430 (of 59,095 total)