Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,576 through 37,590 (of 59,098 total)

RE: TSQL

palla.sureshbabu (7/21/2010)
jeff,
can explain it bit clear how can we schedule the job please post in detail procedure with the script.
Once aging thanks for your reply.
Don't you have 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)

July 21, 2010 at 12:00 pm

#1196367
RE: importing text files with " " around the text

alen teplitsky (7/21/2010)
below is the first few lines of a file i'm trying to import
when i set the text qualifier to " it takes the parentheses off. but i 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)

July 21, 2010 at 11:55 am

#1196360
RE: Fixed length columns

Ram:) (7/21/2010)
Praveen,
If we use Replicate we will have one issue..
if datalength(name)-len(name) is in negative values, I mean actual length of variable is greater than the given datalength.. Then we will...
--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)

July 21, 2010 at 11:47 am

#1196354
RE: FIXED LENGTH OF COLUMN

Praveen Goud Kotha (7/21/2010)
Hi..
I think we can meet your requirement by using REPLICATE function(i.e..Repeats a character expression a specified number of times)
An updated query using REPLICATE is given below
select sno+replicate('...
--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)

July 21, 2010 at 11:42 am

#1196347
RE: “Distinct” column in SQL query results

Praveen Goud Kotha (7/21/2010)
What you are going to achieve with this..??
Can i know where you are going to implement(practically) this..?
Praveen,
Please change your avatar. I made that avatar and I'd...
--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)

July 21, 2010 at 11:35 am

#1196341
RE: Fixed length columns

Praveen Goud Kotha (7/21/2010)
Hi..
I think we can meet your requirement by using REPLICATE function(i.e..Repeats a character expression a specified number of times)
An updated query using REPLICATE is given below
select sno+replicate('...
--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)

July 21, 2010 at 11:32 am

#1196340
RE: SQL CLR Data Types and Performance

Matt,
Could you post the T-SQL Function you ran against, please? Thanks.
--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)

July 21, 2010 at 11:27 am

#1196338
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

kjc-1057161 (7/21/2010)
Thanks Jeff! I've read your Tally tables articles before, but was having a complete blind spot as to how it applied here to this problem I'll run some...
--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)

July 21, 2010 at 6:26 am

#1196104
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Mike C (7/20/2010)
I'll have to look a little closer at that one tomorrow. Is multirow variable aggregation as unsafe as multirow string concatenation?
Gosh, Mike, I'm not sure why people...
--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)

July 21, 2010 at 6:21 am

#1196099
RE: Cursor within DTS

Chris Morris-439714 (7/20/2010)
The UPDATE of the table is a special kind called a Running Totals Update. Jeff Moden has written some excellent and easily consumable articles about them for this...
--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)

July 20, 2010 at 10:17 pm

#1195934
RE: Cursor within DTS

Denesh Naidoo (7/20/2010)
Have a look at the link below:
http://searchsqlserver.techtarget.com/tip/Avoid-cursors-in-SQL-Server-with-these-methods-to-loop-over-records
Sorry but absolutely not. It's not the cursor that makes things slow... it's the WHILE LOOP. Converting a cursor 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)

July 20, 2010 at 10:07 pm

#1195931
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

kjc-1057161 (7/20/2010)
Thanks for both responses! The problem isn't the calculation of compound interest, but the rounding issue, hence all the floor() functions. Each day, the interest is calculated only 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)

July 20, 2010 at 9:53 pm

#1195927
RE: Help with using mulitple replace in a function

Eugene Elutin (7/19/2010)
The fasterst string manipulations would be byte by byte. Not so elegant, a lot of manual coding, but -very fast.
Now, I'll definitely agree with THAT! 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)

July 20, 2010 at 9:20 pm

#1195919
RE: Generating SubTotals using GROUPING

Hugo Kornelis (7/20/2010)
My final comment in this topic, and then I'll respect R.P.'s request.
Jeff Moden (7/19/2010)
Still, the order of run return is, in fact, documented in Books Online...
ROLLUP
Specifies that...
--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)

July 20, 2010 at 9:13 pm

#1195915
RE: BCP Utility

bryan.duchesne (7/20/2010)
No, I am not trying to make the data any longer. In some cases I just want to change the content or blank it out.
I guess we need...
--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)

July 20, 2010 at 9:09 pm

#1195913

Viewing 15 posts - 37,576 through 37,590 (of 59,098 total)