Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,096 through 40,110 (of 59,072 total)

RE: is sql ? is oracle? is sybase? possible to concatenate?

{edit} never mind... I misunderstood something here very badly.
--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 26, 2010 at 4:10 pm

#1108996
RE: Perfect is the Enemy of Good

WolforthJ (1/26/2010)
The next level would be to develop partnerships with people who really have the power to make changes, but I have never made it that far, at least not...
--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 26, 2010 at 4:05 pm

#1108995
RE: convert a number to decimal

Faye Fouladi (1/26/2010)
Suppose:
Declare @mynumber int
Set @mynumber = 10299
How can I return 102.99 from this or if the variable will be given at runtime, how can I process...
--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 26, 2010 at 11:58 am

#1108866
RE: Urgent development question

WayneS (1/25/2010)
CirquedeSQLeil (1/25/2010)
Here is a thread that may help you find your solution. You will still need to look at the code and determine how to adapt it 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)

January 25, 2010 at 5:39 pm

#1108459
RE: extract days,hour,min,sec

lisbon (1/25/2010)
Even simpler:
cast(datediff(dd,0,getdate()) as datetime)
lx
Not exactly what the op asked for but I agree.
--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 25, 2010 at 5:32 am

#1108086
RE: how to get only duplicate rows from table

malleswarareddy_m (1/24/2010)
...but i wasted hours of time...
So, did you take the time to read the article I pointed you to so that doesn't happen anymore?;-)
--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, 2010 at 11:40 pm

#1108016
RE: Is it possible to keep my database in RAM????

Heh... with so many folks talking about separate servers, now I know the real reason why MS deprecated such a useful tool as being able to pin certain tables. ...
--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, 2010 at 11:38 pm

#1108015
RE: Developing a report from two different databases

You're not only changing databases, but instances, as well. I don't know much about SSIS but I'd imagine you'd have to resort to the 4 part naming convention 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)

January 24, 2010 at 5:31 pm

#1107972
RE: Query multiple descriptions from single field of codes

gadall (1/24/2010)
This works perfectly for what I have to do.
Thank you so much.
Heh... 3 solutions were given. Which one did you 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)

January 24, 2010 at 5:29 pm

#1107971
RE: Query multiple descriptions from single field of codes

lobbymuncher (1/24/2010)
Here's a completely different way which returns the codes in the same row.
CREATE TABLE #A (id INT, FCode CHAR(10))
INSERT INTO #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)

January 24, 2010 at 5:28 pm

#1107970
RE: Linked Server View - Production vs Test

Use a linked server with the same name in test and production.
--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, 2010 at 5:24 pm

#1107968
RE: select highest and lowest figures in a group for %ge growth

PLEASE, read the article at the first link in my signature. It will help you help others give YOU a correct answer more quickly. Thanks.
Unless your datatypes are...
--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, 2010 at 5:18 pm

#1107966
RE: Keeping up with Technology

Scott Jacobson-452610 (1/24/2010)
Timothy, I'd argue that you're making excuses. You're right that "things were different 100 years ago" as the OP suggests. However, this is the world 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, 2010 at 4:39 pm

#1107962
RE: Normalization

I was hoping that you'd say that. I agree. All parts of the address are known is it is known that the 2nd address line has a value...
--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, 2010 at 9:20 am

#1107919
RE: Tally Table

Heh... I found it. It's amazing what low levels of caffeine will do to one's eye's. :hehe:
--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, 2010 at 8:59 am

#1107917

Viewing 15 posts - 40,096 through 40,110 (of 59,072 total)