Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,871 through 30,885 (of 59,101 total)

RE: Select columns dynamically

I'm on my way to work and will have a go at it after I get home tonight. Chances are, someone will beat me to it, though. Lot'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)

March 5, 2012 at 8:03 am

#1454807
RE: convert rows into columns

chandarcst (3/5/2012)
Hi
I asked you Send the standard sql tutorial links suppose if you have.
There's no real "standard tutorial" links on the subject by Microsoft. The information is in...
--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)

March 5, 2012 at 7:31 am

#1454791
RE: convert from MM/DD/YYYY to YYYYMMDD

Sorry for going so far out of character on this one, Eugene. I was absolutely amazed by what happened here.
Look further down in the thread. Here'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)

March 5, 2012 at 6:48 am

#1454770
RE: convert from MM/DD/YYYY to YYYYMMDD

BWWWAAAA_HAAAA!!!! I know this thread is old but I think it's a funny thread. Let me replay the whole thing for you...
We have a team that wants...
--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)

March 4, 2012 at 9:03 pm

#1454632
RE: Set fiscal year, have year automatically roll over

I realize that this is an older post and no one may still be listening, but I ran out of "fun" posts and thought I'd give this one a try.
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)

March 4, 2012 at 8:33 pm

#1454628
RE: SELECT to transform a csv of INT into VARCHAR

Henk Schreij (3/2/2012)
Oops,
That's a massive answer 🙂
I'll study your answer. Thanks a lot.
My lookup table is just 20 records, and will never have nore then 50 records.
My drinks table 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)

March 4, 2012 at 7:12 pm

#1454624
RE: SELECT to transform a csv of INT into VARCHAR

Eugene Elutin (3/2/2012)
It may be that I will be killed by the community for the following advice :
Ummmm... so what's your address, Eugene? 😉
--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)

March 4, 2012 at 7:00 pm

#1454623
RE: TSQL - Find maximum running date gap in a date range and also date gap ranking

MidBar (2/27/2012)
1: Any other possibility without CTE?
I have to ask... why didn't you want this with a CTE?
--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)

March 4, 2012 at 6:52 pm

#1454622
RE: Tsql grouping question

John Mitchell-245523 (2/27/2012)
It's best to let your presentation layer handle things like this.
I'll say "It Depends"... especially if there's no presentation layer that can handle it. 😉
--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)

March 4, 2012 at 6:47 pm

#1454620
RE: After server move a query doesn't work anymore

The only way we're going to be able to help is if you take the steps outlined in the article at the second link in my signature. Take 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)

March 4, 2012 at 6:41 pm

#1454619
RE: After server move a query doesn't work anymore

More likely, it's a statistics problem. Did you rebuild all of your statistics with "FULL SCAN" after the server move?
One other trick you might want to try especially since...
--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)

March 4, 2012 at 5:31 pm

#1454611
RE: Calculating the percentage of product revenues for reporting

LutzM (3/2/2012)
Replace A.TOTAL with A.TOTAL*1.00 to avoid an integer divsion (usually resulting in a zero value in such a scenario).
Example:
SELECT 1/2*100, 1/(2*1.00)*100
Just an idea, Lutz. Move the *100 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)

March 4, 2012 at 5:22 pm

#1454610
RE: Calculating the percentage of product revenues for reporting

Sorry, post withdrawn...
--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)

March 4, 2012 at 5:17 pm

#1454609
RE: SUM function assistance

SQL_Enthusiast-AZ (3/4/2012)
I knew it so was simple. I was using distinct and that was throwing the whole thing off... I feel real dumb right now... Sorry for wasting your time....
--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)

March 4, 2012 at 5:14 pm

#1454608
RE: Need an alternative way for using parameters in views

My guess would be that since you're absolutely sure that you need to use a parameter, then don't use the view because views don't take parameters. Rewrite the view...
--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)

March 4, 2012 at 5:11 pm

#1454607

Viewing 15 posts - 30,871 through 30,885 (of 59,101 total)