Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,431 through 35,445 (of 59,099 total)

RE: Please help with SQL code

pwalter83 (1/10/2011)
Hi Jeff,
Thanks a lot for your reply. Please pardon me for the lengthy message below-
Hi Paul,
I'm a wee bit confused. I built your tables, loaded your data, 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)

January 10, 2011 at 5:55 pm

#1271677
RE: 1 point for every 3 multiples in a row

Cory E. (1/10/2011)
Edit: I guess Jeff beat me to it. Thanks!
Apparently, only by a couple of seconds! Great minds think alike. 🙂
--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)

January 10, 2011 at 5:16 pm

#1271671
RE: Assigning values to multiple variables with single SELECT (with a twist)

mishaluba (1/10/2011)
Without going into too much detail, I am tasked with optimizing some code written before my time. There is a stored procedure, which takes a parameter containing delimited...
--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)

January 10, 2011 at 5:14 pm

#1271669
RE: Assigning values to multiple variables with single SELECT (with a twist)

GSquared (1/10/2011)
Since you're using SQL 2008, can you switch from delimited lists of parameter values to a table variable parameter? Those are more efficient.
Ah... guess I need to teach...
--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)

January 10, 2011 at 5:09 pm

#1271668
RE: Please help with SQL code

Hi Paul,
Sorry... my previous response was directed to harinerella.
Thanks for the setup code and test data. Unfortunately, I'm on my way to work and won't be able to look...
--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)

January 10, 2011 at 10:03 am

#1271495
RE: 1 point for every 3 multiples in a row

Simple Integer math should take care of it...
SELECT Col1/3
--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)

January 10, 2011 at 9:55 am

#1271490
RE: Display name of months in a matrix report

I can't help you in SSRS matricies because I don't use SSRS. I can, however, help you with a T-SQL script to do the job. Please see 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)

January 10, 2011 at 8:35 am

#1271444
RE: How to do Recursive program to find Drilldown data

IF you don't have many rows in the hierarchy and IF you don't want to take the time to rework the form of the hierarchical path (it won't sort correctly...
--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)

January 10, 2011 at 8:32 am

#1271441
RE: Please help with SQL code

harinerella (1/6/2011)
Better to write a CTE and finalize the values need to compared and then make the join with simple condition.
Cool! Let's see some code. 🙂
--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)

January 10, 2011 at 8:04 am

#1271413
RE: How to apply only OR filter opertor on more than one columns

azhar rahi (1/10/2011)
I have already resolved it. It was very simple. Thanks by the way.
How did you resolve 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)

January 10, 2011 at 7:58 am

#1271405
RE: SQL help needed with a split function sql server 2008

Sichy (1/10/2011)
Good question! At first i actually didn't have access to the table and i couldn't imagine how many rows it would initialy have so i simply put 999999999999... When...
--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)

January 10, 2011 at 7:51 am

#1271402
RE: SQL help needed with a split function sql server 2008

WayneS (1/9/2011)
Sichy (1/9/2011)
Sichy,
I'm really curious about this line of code:
SELECT TOP 158533281 --158,533,281
What does that number represent? It's a really odd number to use - why not 200 million?
I'll...
--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)

January 9, 2011 at 11:07 pm

#1271248
RE: Assigning values to multiple variables with single SELECT (with a twist)

mishaluba (1/9/2011)
Very nice! Thank you!
Since I have a ton of these assignments in my case, I am hoping for some marginal performance improvement.
Then I have to ask, why are...
--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)

January 9, 2011 at 11:05 pm

#1271247
RE: Trigger regarding

Understood on the time thing. If you get a chance, though, I think it would be a great article. Thanks, Nils.
--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)

January 9, 2011 at 10:57 pm

#1271245
RE: Flat with multiple data sets

Ghanta (1/8/2011)
Jeff Moden (1/8/2011)
Ghanta (1/7/2011)
Hi Guys,
I am sure some of you might have dealt with the situation that I am in... wanted to check the efficient way to do 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)

January 9, 2011 at 8:32 pm

#1271234

Viewing 15 posts - 35,431 through 35,445 (of 59,099 total)