Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,886 through 48,900 (of 59,099 total)

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

Hugo Kornelis (8/7/2008)
As Jeff already said, this might not be the best way to find your first gap. Here are two alternatives that...
Here's another take on the same problem... test...
--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 9, 2008 at 10:42 am

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

Thanks for the feedback, Atif!
--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 9, 2008 at 10:36 am

#855693
RE: Creating a running difference - sort of

Awesome. Thanks for the feedback, Buzz.
--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 9, 2008 at 10:34 am

#855692
RE: Concatentate Column For Duplicate Key record

Dang... Yeaup... I already knew about the prettifier... was hoping there was something a bit more auto-magic... 🙂
--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 8, 2008 at 10:18 pm

#855615
RE: Concatentate Column For Duplicate Key record

Ok... fair trade... I give you a solution... you tell me what you're using to format you code for the code entries on this forum... (please :))
--=====================================================================================================================
-- ...
--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 8, 2008 at 9:14 pm

#855610
RE: BCP Remote Files

You are correct... BCP can write anywhere that the server can "see". The SQL Server SERVICE must have a Windows Server login that can "see" the UNC path that...
--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 8, 2008 at 7:08 pm

#855600
RE: sum multiples matrix SubTotals

marcelo (8/8/2008)
OK. Per example:
first matrix
|jun |jul |aug |total
aaa | 10 | 20 | 15 | 45
bbb | 5 | 7 | 10 | 22
-----+----+----+----+-----
total| 15 |...
--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 8, 2008 at 7:01 pm

#855599
RE: Creating a running difference - sort of

Buzz (8/8/2008)
Thanks Jeff, good article. My solution definitely fits into that category and would probably only work for a very limited number of rows...not a good solution.
With that said,...
--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 8, 2008 at 6:37 pm

#855596
RE: Recursive Queries in SQL:1999 and SQL Server 2005

Two way street, here... would you mind posting your solution? Thanks. 🙂
--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 8, 2008 at 5:13 am

#855031
RE: Beat this - comic relief for the day

Heh... oh boy... some folks are really gonna hate me...
Absolutely the dumbest code I've ever seen is....
SELECT sometestformula from DUAL; :P:P:P:P;)
--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 10:15 pm

#854906
RE: Convert nanoseconds since 1/1/1601

You mean to tell me that LDAP queries can't change the format of the date?
--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 9:15 pm

#854895
RE: sum multiples matrix SubTotals

Sum of all individual items plus their sub-totals is always twice as large as the subtotals themselves. Sum everything and divide by 2.
--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 9:05 pm

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

Viewing 15 posts - 48,886 through 48,900 (of 59,099 total)