Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,901 through 48,915 (of 59,102 total)

RE: Private Emails

Grant Fritchey (8/7/2008)
Thanks for all the responses.
I got one yesterday, I think it was maybe the third one I've received over the years (I'm hardly one of the "go-to" guys)....
--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 7, 2008 at 8:33 pm

#854887
RE: problems with bulk insert

Yes... you need "BulkAdmin" privs...
--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 7, 2008 at 8:28 pm

#854886
RE: Sorting value in a column

Ankur Bhardwaj (8/7/2008)
Hi Christopher,
what is the value of n..........
I am new to SQL Server.
Ankur,
Please see the following link for the answer to that question and, I'm sure, more that 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 7, 2008 at 8:18 pm

#854883
RE: Creating a running difference - sort of

Lori Fortner (8/7/2008)
Statement_num Fees_Due Initials Fees_Billed Credit_Amt
1007 ...
--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 7, 2008 at 8:13 pm

#854879
RE: if-else

murali_babuin (8/5/2008)
thanks..! i got it. I have another problem now.. how can we pass a perameter to call a function from a stored procedure.. please help
Two way street here... if...
--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 7, 2008 at 7:57 pm

#854875
RE: Sum Distinct

giontech (8/7/2008)
Is there a way to do sum distinct in reporting services?
I have a matrix with two column groupings and subtotals for each of them, but I can't find a...
--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 7, 2008 at 7:53 pm

#854873
RE: BCP Remote Files

Angel Miranda Nieto (8/7/2008)
Hello to everyone, I try to explain my problem, i need with BCP utility put a file in remote machine, I writed this script exec master..xp_cmdshell 'bcp...
--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 7, 2008 at 7:51 pm

#854872
RE: Date Breakdown

helloanam (8/7/2008)
I think first and last date of year will always be same irrespective of what year is it. 😉
first date: 01/01/ year
last date: 31/12/ year
therefore, no need to 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)

August 7, 2008 at 7:36 pm

#854869
RE: OpenRowset Bulk Import Flat files with header & Footer

Except for the occasional mispelling, that should do 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 7, 2008 at 6:49 pm

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

Good idea, but be careful... the Tally table is not a panacea. For example, there is code that will beat the pants off the Tally table for finding missing...
--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 6, 2008 at 11:58 pm

#854220
RE: Money vs. Decimal Data type

Tomm Carr (8/6/2008)
Jeff Moden (8/6/2008)
Heh... provided that an inter rate, tax rate, discount rate, or any other rate is never used.
None of which are Money. All those rates will be...
--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 6, 2008 at 11:55 pm

#854219
RE: Urgent help required !!!!!

Thank you for the feedback... glad you solved 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 6, 2008 at 11:49 pm

#854217
RE: Money vs. Decimal Data type

Heh... reminds me of the ol' hand assembly days... "Shift Left, Load Zeros". 😀
--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 6, 2008 at 7:12 pm

#854188
RE: Just For Fun: An Impossible Delete

john.arnott (8/6/2008)
I wasn't trying so much to improve on anyone's solution, but found that just trying to find an alternative approach helped me understand the concept of a tally 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)

August 6, 2008 at 7:09 pm

#854187
RE: Money vs. Decimal Data type

Heh... provided that an inter rate, tax rate, discount rate, or any other rate is never used.
--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 6, 2008 at 6:25 pm

#854182

Viewing 15 posts - 48,901 through 48,915 (of 59,102 total)