Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,546 through 22,560 (of 59,072 total)

RE: Copy SSRS reports from Dev to Stage to Prod.

That's great amplifying information. I'm also glad to see that you can also promote data sources with the understanding that you might need to change some credentials. I'm...
--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 28, 2014 at 9:26 pm

#1755401
RE: Need Create View Script for all tables

DonlSimpson (10/28/2014)
In case anyone thinks this example is a good idea I just want to add my vote to what Sean already suggested, namely: Never, never use SELECT * FROM...
--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 28, 2014 at 9:21 pm

#1755399
RE: do you have a StripNonNumeric ITVF function?

Eirikur Eiriksson (10/28/2014)
Little clean up in the logic, now it looks pretty good
😎
/********************************************************************
-- Stripping out any non-numerical characters
-- EE 2014-10-28 Inital coding
-- EE ...
--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 28, 2014 at 9:08 pm

#1755398
RE: Copy SSRS reports from Dev to Stage to Prod.

As a bit of a sidebar, I read some of the comments that follow that article and some dude said the performance of RS "sucks". When I read 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)

October 28, 2014 at 9:19 am

#1755256
RE: Copy SSRS reports from Dev to Stage to Prod.

Thanks, ol' friend. Great minds think alike. I just found the following example that uses RS and, at first blush, looks fine. Combined with the official link...
--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 28, 2014 at 8:52 am

#1755249
RE: do you have a StripNonNumeric ITVF function?

I took the two contenders from your good post, Alan, and added on of my own. Here's the code for the function I use for such things. Yeah......
--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 28, 2014 at 12:34 am

#1755098
RE: do you have a StripNonNumeric ITVF function?

Out of all of these submittals, which post has the fastest code? I'd check for myself but I'm on the run right now but want to check the "best"...
--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 27, 2014 at 4:17 pm

#1755059
RE: Need help with Index Rebuild and Reorganize job set up.

spaghettidba (10/27/2014)
dinsab11 (10/26/2014)
I even looked Ola Hallengren's scripts but so complicated to make my own.
Please some one post the script here, I would be grateful.
Requirements: (this is on 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)

October 27, 2014 at 8:38 am

#1754954
RE: Dynamically change background color in SSRS reports using custom code

High Marks for you, Stan. Low marks for SSRS, though. I can't believe that there's nothing built in for this very common requirement. It's amazing how much...
--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 27, 2014 at 1:25 am

#1754842
RE: round to two digit after decimel

Lynn Pettis (10/26/2014)
Jeff Moden (10/26/2014)
QQ-485619 (10/26/2014)
what if that is a column name, e.g.
select sum(saletotal)/NumberofDays
select sum(saletotal)/NumberofDays+0.0
Actually: select sum(saletotal)/(NumberofDays+0.0) -- << Remember order of precedence for mathematics.
COFFEE!!! I NEED COFFEE!!! :-D...
--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 26, 2014 at 11:13 pm

#1754833
RE: Rank duplicates, but only rows involved in duplicates

I usually go for a simple million row test but data is getting larger and larger so I thought I'd give everyone the opportunity to play with a table the...
--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 26, 2014 at 10:42 pm

#1754832
RE: Rank duplicates, but only rows involved in duplicates

Eirikur Eiriksson (10/26/2014)
Jeff Moden (10/25/2014)
Eirikur Eiriksson (10/25/2014)
Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day,...
--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 26, 2014 at 8:16 pm

#1754825
RE: round to two digit after decimel

QQ-485619 (10/26/2014)
what if that is a column name, e.g.
select sum(saletotal)/NumberofDays
select sum(saletotal)/NumberofDays+0.0
--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 26, 2014 at 6:10 pm

#1754824
RE: Need help with Index Rebuild and Reorganize job set up.

dinsab11 (10/26/2014)
Hello,
I tried to find online the script I need but unable to do so. I even looked Ola Hallengren's scripts but so complicated to make my own.
Please some...
--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 26, 2014 at 6:04 pm

#1754823
RE: Rank duplicates, but only rows involved in duplicates

Eirikur Eiriksson (10/25/2014)
Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day, keep up the good...
--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 25, 2014 at 1:31 pm

#1754783

Viewing 15 posts - 22,546 through 22,560 (of 59,072 total)