Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,761 through 38,775 (of 59,098 total)

RE: Don't I need a TRY..CATCH block in the stored proc?

Barkingdog (4/23/2010)
The following query works as expected (rolls back everything) but I'm surpirsed. Don't I need to include a TRY..CATCH or a BEGIN TRANS in the stored proc myInsertProc?
TIA,
Barkingdog
CREATE TABLE...
--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 7:40 pm

#1157209
RE: STUFF FUNCTION

mugahjoseph (4/23/2010)
Hi Guys,
I have a column in a table that I have stored in the format;
--/---/--/--
e.g 01/345/76/98
But I need to change it to the format;
--/---/---/--
e.g 01/345/076/98, this is to say,...
--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 7:35 pm

#1157208
RE: Query Performance

trivedi.nikesh (4/23/2010)
Dear Sir,
I am heartily thankful to you. I will apply your suggested measures.
Please correct me if I am wrong
Reason behind Query is not performing good due to (in case...
--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 7:21 pm

#1157207
RE: Displaying varchar as time

malavika.ramanathan (4/23/2010)
Hi All,
I have a DURATION column in one of my tables which is in nvarchar.
that column shows the duration alloted to a praticular task.
The data we get...
--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 7:18 pm

#1157206
RE: Quick question about len

Bhuvnesh (4/23/2010)
Also check ANSI_NULL and ANSI_PADDING settings on both databases ?
Spot on.
--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 7:13 pm

#1157205
RE: Advantage of Using Constraint when adding FK or PK

ramirez.sebastian (4/23/2010)
thank you all, for your answers. Been able to identify the index sounds like a good enough reason for me to use the constraint. If there are any...
--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 7:11 pm

#1157203
RE: Insert into Exec

I believe that OPENROWSET may solve the problem you're having.
--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 7:08 pm

#1157201
RE: Group with Rollups??

iruagawal (4/23/2010)
Thanks Stewart, thanks Paul. Wow Paul, I am speechless. What a solution. Never worked with grouping sets before. Thanks for the introduction.
Now what you need to do is lookup...
--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:58 pm

#1157196
RE: SQL Query Question on Union All

Also, is there a chance that WWW and WWW1 are actually views. Depending on the content of those views, that could really gum up the works, as well.
Last but...
--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:47 pm

#1157194
RE: getting a sum of a sum

mswart-971998 (4/23/2010)
Hello,
I am having trouble changing this SQL to get my desired results.
I am somewhat new to SQL and this command is one borrowed from an existing report.
The way 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 6:40 pm

#1157192
RE: changing @@servername

Heh... at least try to answer your own interview/homework questions. Look it up in Books Online. If you don't know what Books Online is, it's the free "help"...
--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:34 pm

#1157191
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

Viewing 15 posts - 38,761 through 38,775 (of 59,098 total)