Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,746 through 38,760 (of 59,072 total)

RE: JOIN with the resultset from a stored procedure?

You can do this using OPENROWSET. Take a look at Books Online.
--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)

April 23, 2010 at 6:29 pm

#1157189
RE: Maximum Row Size Exceeded - Unsure How

mlocatelli (4/23/2010)
Hi All,
I'm having trouble wrapping my head around this one. I'm making some major structure changes to a table, mostly to dump data I don't need in it. Here...
--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)

April 23, 2010 at 6:27 pm

#1157188
RE: Limiting processing power for a specific query

J Vanderhorst (4/23/2010)
Thanks. That will probably work for around 50% of my clients. For the others that do not have multiple processors, do you have any other suggestions?
Yes......
--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)

April 23, 2010 at 6:26 pm

#1157187
RE: CROSS TAB Query Question.

keyun (4/23/2010)
I read bunch of post here but couldnt able to find out and could not able to come up with the result i want.
Here is the data 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)

April 23, 2010 at 6:14 pm

#1157186
RE: Are the posted questions getting worse?

Roy Ernest (4/23/2010)
Paul White NZ (4/22/2010)
Adam Machanic (4/22/2010)
I'm convinced that it's a cultural thing. Apparently in Indian culture it's okay to copy someone else's work.
I have heard this before too....
--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)

April 23, 2010 at 1:24 pm

#1157111
RE: MCJ - The Missing Link

Lynn Pettis (4/23/2010)
CirquedeSQLeil (4/23/2010)
Lynn Pettis (4/23/2010)
After catching some interesting posts on the water cooler, I think I have another reason to revoke the certification -- plagiarism. I don't think...
--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)

April 23, 2010 at 1:00 pm

#1157103
RE: Using OPENROWSET to import CSV files

Wow... sorry about that, folks. I really lost track of this post.
Simon, after only 5 months of delay :blush:, do you still need any help on 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)

April 23, 2010 at 12:58 pm

#1157102
RE: Substring Function in Where Clause

eseosaoregie (4/23/2010)
Hi Jeff,
Just ran this at work on some of the data and it the first CTE failed because it could convert the string type to datetime.
After running some queries...
--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)

April 23, 2010 at 12:55 pm

#1157098
RE: Centrally located stored procs?

Steve Jones - Editor (4/22/2010)
Hey! someone agrees with me 🙂
Replication can work well for you. Consider that.
Heh... I almost always agree with you... I just hate to admit 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)

April 23, 2010 at 9:16 am

#1156946
RE: When not to use a temporary table?

Dan.Humphries (4/22/2010)
I see what you are saying but surely a select of 20 Mil rows from a properly indexed table is not the same as writing 20 million rows 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)

April 23, 2010 at 9:14 am

#1156945
RE: Substring Function in Where Clause

Let's try this again...
Here's the test harness I used... make sure you read the comments because it builds 17 million test rows in something less than 10 minutes...
-- WARNING... USE...
--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)

April 22, 2010 at 8:35 pm

#1156555
RE: Substring Function in Where Clause

{edit} Just noticed a boo-boo... had to take the code I posted down. I'll be back soon.
--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)

April 22, 2010 at 8:07 pm

#1156548
RE: Sum of column instead of row

Seems to me that a simple UPDATE with a join would do the trick and that's covered extensively in Books Online.
--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)

April 22, 2010 at 3:28 pm

#1156481
RE: OPENROWSET Query limit

I don't believe there's a limit on OPENROWSET. More likely, there's some error in the data especially if the data is actually coming from a file.
--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)

April 22, 2010 at 3:25 pm

#1156478
RE: What Do We Want?

Terry Mott (4/22/2010)
One more:
A built-in date truncation function to strip the time portion from a datetime value.
I guess this is not so big an issue anymore, as you can now...
--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)

April 22, 2010 at 3:20 pm

#1156470

Viewing 15 posts - 38,746 through 38,760 (of 59,072 total)