Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,601 through 45,615 (of 59,095 total)

RE: Why do people need to do this?

RBarryYoung (1/23/2009)
Some day you have to tell me how you get everyone's name like that. :unsure:
Heh... It's easy... be good to good people and then ask. 🙂
To make a longer...
--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)

January 24, 2009 at 8:05 am

#932215
RE: Limiting users to views only in database

gisles (1/24/2009)
I was thinking about option 2 - create another database - but have never done that and do not know how to setup the views to be seen in...
--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)

January 24, 2009 at 7:49 am

#932213
RE: How to replace a cell value with a cell value in previous row

Hemin,
There's another way to do the same thing that's actually much faster if you have a large table you need to do this on. It, too, is covered in...
--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)

January 24, 2009 at 7:20 am

#932207
RE: How to replace a cell value with a cell value in previous row

Garadin (1/23/2009)
He wrote an article on it actually. See the Running Totals link in my signature.
Heh... I'm getting closer... normally, you beat me to this on providing solutions. ...
--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)

January 24, 2009 at 7:02 am

#932205
RE: How to replace a cell value with a cell value in previous row

hemin.shah85 (1/23/2009)
Jeff tons of thanks for this solution. It works perfect for my data. I would definately like to know logic behind this if you can throw some light 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)

January 24, 2009 at 6:54 am

#932204
RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

tony.hayes (1/23/2009)
If it was a simple mail merge that might be possible, but we produce custom legal certificates in house on z-fold self seal documents, as well as W2's etc......
--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)

January 23, 2009 at 9:51 pm

#932172
RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

tony.hayes (1/23/2009)
URL is here:
http://pe.usps.com/text/dmm300/L801.htm
Typical government thinking - they only provide an electronic format in pdf
Thanks, Tony... lemme see what I can 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)

January 23, 2009 at 8:52 pm

#932161
RE: The Set-Based Limit

Like I said... just a little of 2.8 GB... I've got files much larger than that.
I've been through that with 2 companies now... they ignore the flagship product 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)

January 23, 2009 at 8:49 pm

#932158
RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

tony.hayes (1/23/2009)
Sorry, first post ever. The only way I could get the data electronically was to copy from where USPS had posted to their website. An example of...
--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)

January 23, 2009 at 8:08 pm

#932145
RE: select multiple identity values after insert?

Scott D (1/14/2009)
I often can't guarantee that I have anything that is uniquely identifiable that I am inserting into my table.
Not trying to be a smart guy here... just...
--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)

January 23, 2009 at 8:00 pm

#932142
RE: select multiple identity values after insert?

RBarryYoung (1/13/2009)
Abhijit More (1/13/2009)
there is another way which you can use..
1. Take the MAX(userID) before batch insert. this will give you the last UserID before batch insert
2. Perform batch insert.
3....
--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)

January 23, 2009 at 7:56 pm

#932140
RE: select multiple identity values after insert?

bagofbirds (1/8/2009)
Fantastic. Thanks for everyone who took the time to think about, and reply to, my question. Thanks especially to RBarryYoung who's solution elegantly solves the whole problem....
--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)

January 23, 2009 at 7:54 pm

#932137
RE: How to replace a cell value with a cell value in previous row

Ray M (1/23/2009)
Your not giving us enough information.
How do we know which row is the first row?
The one with the value or the one that is blank.
Do you have an...
--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)

January 23, 2009 at 7:48 pm

#932133
RE: How to replace a cell value with a cell value in previous row

Actually... good post... I get it. To make future posts just absolutely perfect, take a look at the link in my signature below... THAT's how we like to see...
--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)

January 23, 2009 at 7:36 pm

#932131
RE: Newbie:Why is select doing a table scan?

David's recommendation is pretty much, spot on. Since you're a newbie at this, you may want to visit W3Schools.com and learn how to join tables without creating an alias...
--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)

January 23, 2009 at 7:12 pm

#932128

Viewing 15 posts - 45,601 through 45,615 (of 59,095 total)