Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,021 through 37,035 (of 59,072 total)

RE: database mail without cursors?

The only thing I'm missing is how YOU call the EXEC that sends an email for you. (Trying to give you a complete solution).
--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)

August 30, 2010 at 9:07 pm

#1214023
RE: check if Row exists in the table

SwePeso (8/30/2010)
At least use
SET @CurrencyAmountID = SCOPE_IDENTITY()
instead of
SET @CurrencyAmountID = @@IDENTITY
@@IDENTITY will give you the latest created identity value in the database, no matter which table or user created 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)

August 30, 2010 at 7:20 pm

#1214011
RE: How to Tune Data Inserts

Mr.SQL DBA (8/30/2010)
Jeff,
You are absolutely correct. Tuning of Inserts is as Important as Tuning the Selects.
so i want any options or any types or any methods or any scenarios...
--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)

August 30, 2010 at 7:16 pm

#1214010
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Anthony,
Here's a direct replacement for your sprTablixTest with three very important differences (that you may or may not want)...
1) It creates different data every time you use it instead...
--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)

August 30, 2010 at 7:09 pm

#1214009
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

AnthonyR (8/30/2010)
I just thought I'd share a head-smacking moment with you. It's been touched-on previously in this thread, but I don't think anyone's come right out and demonstrated it.
Thanks 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)

August 30, 2010 at 6:28 pm

#1214007
RE: Sumof previous columns (in pivot table)

aykut canturk (8/29/2010)
yes actually. but column count and column names are changing all the time. so I beleive a kind of "for each column..." structure needed. and the the sql...
--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)

August 30, 2010 at 7:57 am

#1213735
RE: GETDATE Value During Long Running Job

Agreed. If the date mustn't change, then storing it in a variable is definitely the way to go just to be on the safe side.
--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)

August 30, 2010 at 7:23 am

#1213698
RE: check if Row exists in the table

Don't use @@IDENTITY for this. It could cause the wrong number to be returned if certain things happen to the database in the future. Use SCOPE_IDENTITY() instead. ...
--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)

August 30, 2010 at 7:20 am

#1213696
RE: How to bulkinsert a particular column to sql table

nithiyanandam-447806 (8/30/2010)
but we can't bulk insert the table..
it expects status columns.
Obviously, you've correctly identified the problem. You'll need to change something about that. My recommendation is to NEVER...
--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)

August 30, 2010 at 7:17 am

#1213695
RE: how to get the results of a subquery as a commaseparated list

Karl-452938 (8/26/2010)
Complete table definitions would include a lot of stuff, that is not needed here.
Let's keep it simple
We have one table Files, which has 2 fields we need here
-FileID...
--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)

August 30, 2010 at 7:03 am

#1213694
RE: The Great Debate!

steve.robson 58295 (8/26/2010)
Just a few of comments on the posts above . . .
1 - It always depends, but you should try to adopt a standard approach, some general guidelines...
--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)

August 29, 2010 at 7:20 am

#1213529
RE: Turn a Bad Job into a Good Experience

On the flip side of all this, people make a huge difference either way. A great job can suddenly become a major PITA based on a change in someone'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)

August 29, 2010 at 7:09 am

#1213526
RE: Sumof previous columns (in pivot table)

aykut canturk (8/28/2010)
wow, quick answer. yes I have no data, sorry I know it would be easy. okay, let me put in that way. here's sample data:
Product Col1...
--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)

August 29, 2010 at 7:03 am

#1213525
RE: sql server architecture

j.venugr (8/28/2010)
i got architecture from your forum, but i need brief explanation about sql sever architecture to understand very clearly, so please send the explanation, my mail ID is j.venugr@gmail.com
It'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)

August 29, 2010 at 6:57 am

#1213524
RE: recursive or a better way to solve this problem

thava,
Does that answer your question for you?
--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)

August 29, 2010 at 6:45 am

#1213523

Viewing 15 posts - 37,021 through 37,035 (of 59,072 total)