Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,776 through 35,790 (of 59,102 total)

RE: Need help building a query.

sri76 (12/6/2010)
Hi,
Try this query
Select Distinct x.auID, x.Emp_ID, x.dt_Start, (Select top 1 dt_End From auData Where dt_End > x.dt_Start) as dt_End
From
(Select auID, Emp_ID, dt_Start, Emp_Cat From auData Where dt_Start 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)

December 6, 2010 at 7:53 pm

#1259330
RE: Are the posted questions getting worse?

Alvin Ramard (12/6/2010)
Jeff Moden (12/6/2010)
Kit G (12/6/2010)
Steve Jones - SSC Editor (12/6/2010)
... It's actually impossible to get a real person at google.
Ah ha! I knew it! Google 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)

December 6, 2010 at 7:47 pm

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

Paul Muharsky-474732 (5/20/2010)
I disagree that all your SQL should be optimized to 1 million+ records.
Heh... Yeah... I know I'm responding to an old post but the kind of attitude...
--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)

December 6, 2010 at 7:27 pm

#1259326
RE: Returning the Top X row for each group

Idea Deadbeat (12/6/2010)
Not directly related to article - but - an alternative to spt_values:
create table #Number (number int);
with N4000 as (select 0 as Number union all select Number+1 from N4000...
--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)

December 6, 2010 at 6:36 pm

#1259320
RE: Parse text in a string

Black Mamba (12/6/2010)
The second one works better for me..
That's cool. What do you mean "better", though?
--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)

December 6, 2010 at 5:10 pm

#1259303
RE: Previous Month Function

The Dixie Flatline (12/6/2010)
If I understand you correctly, you always want the start and end dates from the prior month, regardless of the starting and ending date that you provide....
--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)

December 6, 2010 at 4:28 pm

#1259292
RE: Count number of rows in all tables..

coolakhil4u6 (12/5/2010)
so I want to do it SSIS totally...
I don't even know how to spell "SSIS" so I can't help there. I am curious, though... why do 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)

December 6, 2010 at 4:26 pm

#1259290
RE: Parse text in a string

ScottPletcher (12/6/2010)
I think you can do that more easily, like so:
SELECT SUBSTRING(col1, (CHARINDEX('Website is', col1) + 11),
CHARINDEX(' because', col1, (CHARINDEX('Website is', col1) + 11)) -
...
--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)

December 6, 2010 at 4:18 pm

#1259286
RE: Are the posted questions getting worse?

Kit G (12/6/2010)
Steve Jones - SSC Editor (12/6/2010)
... It's actually impossible to get a real person at google.
Ah ha! I knew it! Google is run by Space Aliens!
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)

December 6, 2010 at 4:07 pm

#1259279
RE: Huge tables with no appropriate column for creating clustered index !

steven.malone (12/6/2010)
Now that the religious(ish) discussion of heap vs. clustered has been resolved let's circle back to the original post.
IMHO it was a teachable moment for us to reach many...
--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)

December 6, 2010 at 3:59 pm

#1259277
RE: Speed

sjimmo (12/6/2010)
Jeff
Heh... <soap box mode on>
I went looking for your desk, thought that you were sitting next to me or at least close by:hehe:
I standardize on a minimum of 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)

December 6, 2010 at 3:53 pm

#1259274
RE: temp table usage

natarshia.peck (12/6/2010)
i just suggested they create views on the sql server side
Depending on how they build the view and then access it, that could make matters worse... much, much...
--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)

December 6, 2010 at 3:50 pm

#1259273
RE: Remove non printable characters

telastruct (12/6/2010)
Here's another approach:
http://iso30-sql.blogspot.com/2010/10/remove-non-printable-unicode-characters.html
Thanks for the link and welcome aboard! Shifting gears, please be sure to test that code from that link for performance before you think of using...
--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)

December 6, 2010 at 3:41 pm

#1259267
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Paul Herbert (12/6/2010)
I guess this makes me a lurker no more.
Ladies and Gentlemen... meet Paul Herbert. He's the new Systems DBA where I work. We've only been working...
--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)

December 6, 2010 at 2:47 pm

#1259235
RE: Arithmetic overflow error converting expression to data type datetime.

Single Quotes...
select count_big(*) from HECHOS_MOVTO_PREPAGO_ACTUACIONES
where FEC_ACTUALIZACION >= '20090201' and FEC_ACTUALIZACION <= '20091231'
--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)

December 5, 2010 at 5:56 pm

#1258860

Viewing 15 posts - 35,776 through 35,790 (of 59,102 total)