Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,641 through 44,655 (of 59,095 total)

RE: split date and time from datetime

dmoldovan (3/12/2009)
Try also:
CONVERT(CHAR(8), GETDATE(), 114)
CONVERT(CHAR(8), GETDATE(), 108)
No... not for the application the OP is going to use and almost never for everything else because both methods are slow due 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)

March 12, 2009 at 6:50 pm

#958865
RE: how can i convert this date'200702071630+1100' in datetime or in string '20070207'

karthikeyan (3/11/2009)
Can you explain it how it is internally trated by sqlserver? how it is opearting internally? how the memory structure will differ for each function?
if you see REVERSE() 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)

March 12, 2009 at 12:30 am

#958091
RE: SQL Server 2005 Paging – The Holy Grail

First of all... very well written article. Nice to see examples like that with some performance stats. Unfortunately, the most important performance for the user (duration) wasn't measured...
--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)

March 12, 2009 at 12:18 am

#958087
RE: Get Month Name

You bet... thanks for the feedback.
--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)

March 11, 2009 at 9:33 pm

#958058
RE: Can I make this any faster

Bob Hovious (3/11/2009)
Jeff, I understand about pre-aggregating, but why is it so important to do it with a temp table, rather than a derived table? Just so you...
--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)

March 11, 2009 at 9:28 pm

#958056
RE: Transact-sql for changing a telephone number

aram_golbaghi (3/11/2009)
hi
i think gsquare's solution is verywell,
works fine
Yep... right up until you dial a 1 or 3 digit country code instead of +44.
Country codes can be from 1 to 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)

March 11, 2009 at 9:05 pm

#958048
RE: Transact-sql for changing a telephone number

Spikemarks (3/11/2009)
I have tweeked the code and have put it inside a cursor which should read the first 3 chars and then change to which ever it should be.
Once I...
--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)

March 11, 2009 at 8:59 pm

#958046
RE: How do I select a specific entry from a select top nn statement

Heh... close... the next question will likely be "How can I parameterize the TOPs in SQL Server 2000?"
--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)

March 11, 2009 at 8:42 pm

#958039
RE: Straighten me out using "Top 1"

Tony (3/11/2009)
Jeff - he is a beginner, this is his first job out of tech school, and we hired him because we saw his potential for learning. I never...
--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)

March 11, 2009 at 8:11 pm

#958033
RE: Sql Query problem

sumit-saini (2/16/2009)
Hi Jeff,
Thanks for the code, but i will be test the code tommorrow @ my work and i will be able to tell you the performance of this logic...
--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)

March 11, 2009 at 7:55 pm

#958032
RE: Question executing a Store Procedure

Sorry for the late reply. My answer would be "Nope... I'll use a temp table"... just wanted folks to know that it could actually be done.
--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)

March 11, 2009 at 7:45 pm

#958031
RE: OpenRowSet Error

KT8177 (3/11/2009)
I just wanted to updated everyone and say that we have found the issue. It was a memory issue, the server had AWE enabled but 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)

March 11, 2009 at 7:39 pm

#958029
RE: How to select data in t-sql

Heh... nope... see above where I posted...
SELECT ID
FROM #Test
WHERE Countries IN ('IN','AU')
GROUP BY ID
HAVING COUNT(*) = 2
--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)

March 11, 2009 at 7:33 pm

#958028
RE: How to convert YYYYMMDD to datetime using SSIS Data Conversion?

Heh... thanks for posting your solution. I guess that's why I don't like DTS or SSIS... T-SQL makes it so much simpler...
DECLARE @SomeDate VARCHAR(8)
SET @SomeDate...
--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)

March 11, 2009 at 7:30 pm

#958025
RE: How do I select a specific entry from a select top nn statement

That was the first question... now, let's see if the final question about this comes up. 😉
--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)

March 11, 2009 at 7:25 pm

#958020

Viewing 15 posts - 44,641 through 44,655 (of 59,095 total)