Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,111 through 37,125 (of 59,098 total)

RE: Missing sequence number

WayneS (8/26/2010)
Jeff Moden (8/26/2010)
jvanderberg (8/26/2010)
Didn't you ask if it could be done in one SELECT statement?
Who? The OP? I don't see that anywhere in the original or subsequent...
--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 26, 2010 at 11:09 pm

#1212719
RE: Convert CSV values in three columns to rows

The initial testing I just got done doing looks pretty darned good on a parameter of 100,000 elements, Oleg. I'm still playing with 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 26, 2010 at 5:27 pm

#1212640
RE: Missing sequence number

jvanderberg (8/26/2010)
Didn't you ask if it could be done in one SELECT statement?
Who? The OP? I don't see that anywhere in the original or subsequent posts by the...
--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 26, 2010 at 4:54 pm

#1212624
RE: Missing sequence number

Ram:) (8/25/2010)
Thanks for all replies..
I have used following function and select statement . Please clarify me if i am wrong.
Ok, it's wrong because it uses a WHILE loop.
It's also...
--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 26, 2010 at 4:44 pm

#1212621
RE: Missing sequence number

drew.allen (8/25/2010)
This is not a complete solution. It SEEMS to work here, because all of the gaps in your sample data are one ID. If you had gaps...
--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 26, 2010 at 4:41 pm

#1212619
RE: How to Pivot using T-SQL

sqlbi (8/26/2010)
i tired in so many ways and im getting error...
Cool... let's see what you've tried. Also, take a peek at the first link in my signature line below....
--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 26, 2010 at 4:34 pm

#1212614
RE: Encrypting text file to UTF8 using powershell

I have to ask... Am I the only one concerned that someone responsible for the successful encryption of data that needs to be encrypted doesn't know that UTF-8 isn't 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 26, 2010 at 4:23 pm

#1212608
RE: Aging Calculation for Items, Based on Status

homebrew01 (8/26/2010)
I'm stuck, but I know this can't be too hard.
I have warehouse transactions that are used to calculate how long an item has been in the warehouse (aging),...
--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 26, 2010 at 4:02 pm

#1212598
RE: Are the posted questions getting worse?

BrainDonor (8/26/2010)
Paul White NZ (8/25/2010)
Made me think of the new Air New Zealand safety video:
http://www.youtube.com/watch?v=9f1awn9vBZE
My wife is suddenly more interested in our flight out there in February and wants 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)

August 26, 2010 at 7:07 am

#1212268
RE: Normalize a table query

bonggoy cruz (8/24/2010)
I did use unpivot. I was actually aware and have used PIVOT before. I felt kind of stupid when UNPivot was suggested :D. Sometimes the...
--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 25, 2010 at 10:46 pm

#1212057
RE: Plzz help me in replacing the cursor with Normal Sql Statements

LutzM (8/25/2010)
@mike-2: The quirky update method should not be used on joined tables. See Jeff's revised article[/url] for details.
Other than that: as just confirmed the target system is SS2K5. No...
--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 25, 2010 at 10:42 pm

#1212055
RE: Plzz help me in replacing the cursor with Normal Sql Statements

inampudianil (8/25/2010)
Hey Jeff,
Thanks for your help and time dude
I realize that there's a bit of a language barrier and that a lot of foreigners think the we like to 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 25, 2010 at 10:34 pm

#1212052
RE: The Logic, Mathematics, and Utility of NULLs

Tom.Thomson (8/25/2010)
Steve Jones - Editor (8/25/2010)
I do agree that a qualifier of some sort, different for each domain, may be what is needed. In practicality, the issue is how do...
--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 25, 2010 at 10:21 pm

#1212048
RE: Are the posted questions getting worse?

Roy Ernest (8/25/2010)
@jeff. I never set up the netmeeting. I am going to see how that can be done.
When you figure it out, send me an email and then let'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 25, 2010 at 9:58 pm

#1212040
RE: Creating new Database for a large Enterprise

djdhere (8/25/2010)
Hello All,
I need some help with creation of DB for a Bank ERP software
(Its having near about 300 branches )
Main Bank -> Their branches.
My queries are that -How we...
--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 25, 2010 at 9:50 pm

#1212037

Viewing 15 posts - 37,111 through 37,125 (of 59,098 total)