Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,676 through 45,690 (of 59,095 total)

RE: datediff mm between a timestamp in varchar(50) and a small datetime ???

Also, be real careful with ISDATE... the following will return a "1" as will many other things...
SELECT ISDATE('2008')
--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 22, 2009 at 11:50 am

#931355
RE: datediff mm between a timestamp in varchar(50) and a small datetime ???

JPLeBlanc (1/22/2009)
Jeff,
I beleive that would be two months since it is calculating it in days correct?
so not just 1 calendar months difference. or am i backward? 🙂
Lynn is...
--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 22, 2009 at 11:48 am

#931353
RE: Truncating Date

mathur.akhil (1/22/2009)
I have a similar problem. I have lots of tables where the time part is getting stored and need to quickly ensure only the date is stored without changing...
--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 22, 2009 at 5:57 am

#931061
RE: 16 digit unique number

Paresh Prajapati (1/21/2009)
One table has one field and it should be 16 didgit as per client requirement...
Programmer has given me this task...
But, that's not the business reason and you should...
--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 22, 2009 at 5:48 am

#931054
RE: Hidden RBAR: Triangular Joins

ALZDBA (1/22/2009)
Jeff Moden (1/21/2009)
... simple question... "Using a SELECT statement, how do you return the current system date and time as part of the return in either?" ....
Bad 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 22, 2009 at 5:40 am

#931043
RE: VM... Setting up new "box"

Michael Earl (1/22/2009)
Jeff Moden (1/21/2009)
Ok... still not sure what you mean, so I'll come right out and ask... Do you think I'm part of the problem on this one?
No, sorry....
--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 22, 2009 at 5:21 am

#931026
RE: Problem with NULL value

Kent Waldrop (1/21/2009)
Another alternative to the ISNULL function is the COALESCE function; both will work. In addition, COALESCE will also work with both DB2 and Oracle.
In SQL Server, COALESCE...
--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 21, 2009 at 9:23 pm

#930872
RE: datediff mm between a timestamp in varchar(50) and a small datetime ???

JPLeBlanc,
Just making sure that you know what you're getting...How many months would you say the following should give?
StartDate EndDate
20080101 20080229
--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 21, 2009 at 9:17 pm

#930870
RE: Correct use of @variables and uniqueidentifiers

BWAA-HAA!!! Ooooohhh mmmmyyy! Dammit! Stop it, Sergiy... I can't stand laughing this hard! :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)

January 21, 2009 at 8:24 pm

#930864
RE: Risk and Assumptions

I would be working to lower risk as much as possible. Adopting techniques that you are confident in, learning new skills and then applying them, even in side projects, can...
--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 21, 2009 at 8:17 pm

#930863
RE: please help me.. while loop

venkatesh.kuppili (1/21/2009)
Finally everything is working..
Thank you very much for your replies..
So, can we see your final code?
--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 21, 2009 at 8:12 pm

#930862
RE: Is Vince Iacoboni still around?

So... what's the link for the article/script?
--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 21, 2009 at 8:02 pm

#930859
RE: Transaction Times on Very Large Table

What is the clustered index or key based on? Does it maintain the order that something was inserted or does it try to maintain some other order that would...
--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 21, 2009 at 8:01 pm

#930858
RE: What are the Party Plans?

BWAA-HAA!!! I'll bring some eats... everyone like pork chops? 😛
--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 21, 2009 at 7:56 pm

#930854
RE: CORRUPT A DATABASE

Heh... just tell it to run for office. 😛
--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 21, 2009 at 7:55 pm

#930853

Viewing 15 posts - 45,676 through 45,690 (of 59,095 total)