Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,546 through 37,560 (of 59,072 total)

RE: Fixed length columns

Ram:) (7/21/2010)
Hi,
Sorry.. I was reposted this before Lynn's reply.. Thanks everybody and Lynn..
Please correct me on using replicate..
Ah... understood.
Either way is fine for performance.... the CAST method is a bit...
--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:23 pm

#1196400
RE: Add dash to data

Adam Haines (7/21/2010)
I agree with Joe that this should be done in the presentation/application layer. I understand that sometimes this is beyond your control. If you absolutely must...
--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:21 pm

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

alen teplitsky (7/21/2010)
thx
as soon as i got rid of that quote it went further than line 3 and to line 41. now i have to check the entire file which...
--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:20 pm

#1196392
RE: Recursive CTE to replace a cursor problem

Robb Melancon (7/20/2010)
Hey Jeff,
I have read through the discussion pages related to your article titled "Solving the Running Total & Ordianl Rank Problems". There is also another thread with...
--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:13 pm

#1196382
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

Viewing 15 posts - 37,546 through 37,560 (of 59,072 total)