Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,921 through 16,935 (of 59,067 total)

RE: Cast Varchar to Float Resulting In (Scientific) E Notation

GilaMonster (8/26/2016)
Start by identifying how many digits of precision you need.
Because, even if we had infinite precision calculations, when displaying the data back to users, we're not going 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 26, 2016 at 8:13 am

#1897814
RE: Remove 'spaces' from DB backup filename

J2B (8/26/2016)
I need some help to remove the spaces from my backup job...
Its outputting as:
"dbname_DD MMM YYYY.bak"
But I would like:
"dbname_DDMMMYYYY.bak"
Heres my T-SQL...
USE dbname
DECLARE @dbname varchar(200)
SELECT @dbname='filepath\dbname_' + REPLACE(convert(varchar(20),GetDate(),106),':','-') + '.bak'
BACKUP...
--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 26, 2016 at 8:09 am

#1897811
RE: WeekNumners to be renamed

sharonsql2013 (8/25/2016)
I am getting last 4 week numbers in a query - say 31 thru 33.
How can I rename 31 as week 1 , 32 as week2 , 33 as...
--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 26, 2016 at 1:09 am

#1897712
RE: Query output not display in HTML format

SQL Galaxy (8/26/2016)
Hi Jeff.. Thanks as per your suggestion after adding as below line multiple Query result comes in Email body as desired but second set of results not comes...
--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 26, 2016 at 1:08 am

#1897711
RE: Seconds to hours??

The Dixie Flatline (8/25/2016)
I'm wondering why you store staffed time in seconds. How much do you pay per second? 😛
Been there and done that. It's...
--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 26, 2016 at 12:51 am

#1897709
RE: SQL help - how do we find that a particular string appears x times in a certain field

Matt Miller (#4) (8/25/2016)
I'm sorry if I am taking the fun out of building a SQL only solution, but there are lots of basic samples of SQLCLR showing how 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)

August 26, 2016 at 12:47 am

#1897708
RE: Query Performance Tuning – A Methodical Approach

Grant Fritchey (6/9/2015)
There are places where partitioning can, and does, improve performance.
Apologies for the year late response and I hate to be contrary but everywhere I've seen someone make...
--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 26, 2016 at 12:26 am

#1897703
RE: Cast Varchar to Float Resulting In (Scientific) E Notation

waxingsatirical (8/25/2016)
Well what is the "Why"? Why are floats not considered best practice by some?
I don't know what unnecessary work later is incurred by using floats, but I know 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 25, 2016 at 11:19 pm

#1897699
RE: Executing dynamic functions in table select

The Dixie Flatline (8/25/2016)
Sorry, but functions can't call procedures. They can only call other functions. Period.
Any bets on 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)

August 25, 2016 at 8:31 pm

#1897689
RE: Are the posted questions getting worse?

Michael L John (8/25/2016)
Ray K (8/24/2016)
Ed Wagner (8/23/2016)
Ray K (8/23/2016)
Woo-hoo! Just found out that I'm speaking at SQL Saturday #545 in Pittsburgh!
Congratulations, Ray. I hope to see 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 25, 2016 at 8:09 am

#1897480
RE: The Future for Database Administrators

From the Article:
The bar may be raising in terms of skills needed from database IT pros
Heh... they can start by learning how to get the current date and time using...
--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 25, 2016 at 8:08 am

#1897478
RE: Cast Varchar to Float Resulting In (Scientific) E Notation

waxingsatirical (8/25/2016)
Luis Cazares (6/3/2016)
using float is just lazy programming.
and by 'lazy' you mean??? Not doing unnecessary work?
No. More like not wanting to be bothered with best practice details,...
--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 25, 2016 at 7:49 am

#1897467
RE: Cast Varchar to Float Resulting In (Scientific) E Notation

Wryan138 (6/3/2016)
Ron,
If they really must have their floating point columns you might want to try:
Str(ThatFloatField, 5, 2) -- nnn.nn
It will round the result (not truncate).
Wayne
That would slow things down...
--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 25, 2016 at 7:47 am

#1897466
RE: Executing dynamic functions in table select

paulo.margarido (8/24/2016)
i know my first aproach its uggly, and oi wanted to learn something more, and i do
Very cool. The first step is to stop saying things like...
i have...
--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, 2016 at 8:49 pm

#1897371
RE: Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement

@greg Larsen,
Your the one that got paid some decent money for posting this series. How about you answer some of the questions for a change!
--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, 2016 at 8:34 pm

#1897369

Viewing 15 posts - 16,921 through 16,935 (of 59,067 total)