Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,126 through 40,140 (of 59,098 total)

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
RE: Need help to built SQL statement

Wow! Nicely done, miss.delinda. There are people on this site who have >500 posts that still haven't figured out how to get the best help and you nailed...
--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, 2010 at 10:45 pm

#1107879
RE: Avoiding Log full Error

mahesh.vsp (1/23/2010)
I feel, irrrespective of recovery model , until the txn is completed, the LDF file keeps increasing and once completed only then it can be re-used by other transaction.
That'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)

January 23, 2010 at 10:40 pm

#1107878
RE: Query optimization

I believe I'd use UNION ALL for this. UNION essentially does a distinct which is probably not necessary here.
--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, 2010 at 10:31 pm

#1107877
RE: Tally Table

RBarryYoung (1/23/2010)
Jeff Moden (1/7/2010)
... there's likely a set based solution that will keep all forms of RBAR at bay here.
Heh. Well, all but one ... 😀
Where did you get...
--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, 2010 at 10:24 pm

#1107876

Viewing 15 posts - 40,126 through 40,140 (of 59,098 total)