Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,091 through 30,105 (of 59,101 total)

RE: get last 5 year date

declare @todate datetime
select @todate = '09/30/2010'
SELECT FiveYearsPrevious = DATEADD(yy,-5,@todate)
--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)

May 11, 2012 at 9:49 pm

#1486697
RE: Converting first letter of every word to uppercase

opc.three (5/11/2012)
Jeff Moden (5/11/2012)
Do you have any performance metrics for this, Orlando?
I do not, but I would be happy to mock up some test data and run some tests. I...
--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)

May 11, 2012 at 9:07 pm

#1486693
RE: improve performance of sp

Lynn Pettis (5/11/2012)
Jeff Moden (5/11/2012)
Lynn Pettis (5/10/2012)
Jeff Moden (5/10/2012)
So much time wasted.
Maybe, but it is my time to waste. I'm not going to apologize for hoping against hope 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)

May 11, 2012 at 8:50 pm

#1486691
RE: Converting first letter of every word to uppercase

opc.three (5/11/2012)
.NET has this functionality built-in and does a pretty good job. It may not be exactly what you want, but I thought it was worth mentioning. Here is 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)

May 11, 2012 at 7:35 pm

#1486684
RE: return null value sum field when no data is available

vahid.arr (5/10/2012)
i want when no data is available (on where statement no data is exist) return nothing not null value
select
SUM(isnull([TedadTarhModiriatTafzili],0))as TedadTarhModiriatTafzili
, SUM(isnull([TedadTarhModiriatJame],0))as TedadTarhModiriatJame
, SUM(isnull([TedadKhodro],0))as TedadKhodro
, SUM(isnull([TedadMotorcycle],0))as TedadMotorcycle
, SUM(isnull([TedadGhayegh],0))as TedadGhayegh
, SUM(isnull([TedadBisim],0))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)

May 11, 2012 at 8:53 am

#1486361
RE: improve performance of sp

Lynn Pettis (5/10/2012)
Jeff Moden (5/10/2012)
So much time wasted.
Maybe, but it is my time to waste. I'm not going to apologize for hoping against hope for the best. I...
--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)

May 11, 2012 at 8:44 am

#1486349
RE: improve performance of sp

opc.three (5/10/2012)
Lynn Pettis (5/10/2012)
Jeff Moden (5/10/2012)
So much time wasted.
Maybe, but it is my time to waste. I'm not going to apologize for hoping against hope for 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)

May 11, 2012 at 8:43 am

#1486347
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

Gullimeel (5/11/2012)
select * from
(
select id,max(case when cd = 'A' then 1 else 0 end) + max(case when cd = 'B' then 2 else 0 end) + max(case when cd...
--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)

May 11, 2012 at 8:37 am

#1486340
RE: A brief overview of mechanisms to "export to excel" - which do you use, which do you prefer?

True ernough but if it were only 4 or 5 people who wanted a single spreadsheet, it wouldn't really be a problem, would it? The real problem is 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)

May 11, 2012 at 8:34 am

#1486337
RE: Please fix the "Pretty Print" class in the forums and the article "Contribution Center"

OH! THOSE rabbits! Yeah... they went screaming by yelling something about a tent in the desert.
--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)

May 10, 2012 at 7:07 pm

#1486070
RE: Passing Parameter with a wildcard

Didn't look to see if it was mentioned before but one sure fire way to increase the performance here would be to use UNION ALL instead of UNION. UNION...
--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)

May 10, 2012 at 7:01 pm

#1486068
RE: return null value sum field when no data is available

Because tyou can't do much with null.
What do you want it to return? 0? If so, wrap each SUM in an ISNULL.
--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)

May 10, 2012 at 6:55 pm

#1486067
RE: A brief overview of mechanisms to "export to excel" - which do you use, which do you prefer?

The very last option is one of the best options IMHO. Even though it requires extra infrastructure, it will give the users a recent copy of production where they...
--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)

May 10, 2012 at 6:50 pm

#1486066
RE: improve performance of sp

So much time wasted.
--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)

May 10, 2012 at 6:22 pm

#1486054
RE: BCP exported image is not valid

AShehzad (5/9/2012)
I have exported various images from Image type column through bcp. The resultant files show valid size but could not be opened due to corrupt image format.
I...
--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)

May 10, 2012 at 6:01 pm

#1486049

Viewing 15 posts - 30,091 through 30,105 (of 59,101 total)