Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,466 through 33,480 (of 59,099 total)

RE: How to output query results as fixed length fields

Jim Woods (6/26/2011)
How can I change NULL results to be blank instead of NULL?
ISNULL(somecolumn,'')
How can I save the results without , between fields?
Concatenate the columns into one big column.
ColumnA+ColumnB+ColumnC+....
--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)

June 26, 2011 at 5:42 pm

#1344269
RE: Split the data in the row seperated by comma

kamala_moorthy (6/20/2011)
Thanks Jeff.
Regards,
Kamal
You're welcome. But you still didn't answer my question and this IS a two way street here. 😉 Why do you need to do this 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)

June 26, 2011 at 5:07 pm

#1344267
RE: Need to Create File Listing through T-SQL

mail2payan (6/19/2011)
Dear MidBar; Jeff Moden,
Thanks for quick reply.
I tried, but not working, but when am using the following procedure: exec xp_dirtree '\\server1\FILE_MANAGEMENT\air\air11', 0, 1, it's working properly, why is 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)

June 26, 2011 at 5:05 pm

#1344266
RE: how to print characters after third occurrance of a character

... and, even after a week, I STILL want to know. Where the hell did the OP go? 😉
--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)

June 26, 2011 at 4:59 pm

#1344265
RE: Normalization

PaulB-TheOneAndOnly (6/23/2011)
fourteen, fourteen pages already on this thread!!! :w00t:
There is an abundant amount of information on the posts of this thread but I'm affraid most people wouldn't read it from...
--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)

June 26, 2011 at 4:44 pm

#1344263
RE: Slow performance after Migration from Access to SQL back-end

If you do add a column to a table, make sure you rebuild at least the clustered index.
As a side bar, you might want to avoid using ORDER BY X...
--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)

June 26, 2011 at 4:40 pm

#1344262
RE: Does anyone have a good reason to run xp_CmdShell?

Craig Farrell (6/23/2011)
opc.three (6/23/2011)
OK, that was not what I was thinking of. I now have something to go read up on, thanks 🙂
I won't let the cat completely out of...
--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)

June 26, 2011 at 4:33 pm

#1344261
RE: Analytical Interview Questions

james.morrison 19355 (6/23/2011)
Jeff Moden (6/23/2011)
james.morrison 19355 (6/22/2011)
Would you really put an MCM through all of that? If the person had 3 years of experience at Microsoft, would you really be...
--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)

June 26, 2011 at 12:24 pm

#1344235
RE: Increment Identity Column Value

raistlinx (6/25/2011)
I've seen data migration projects do this where you were generating a new lookup table for migrating many environments into one. Each environment would get a seed number and...
--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)

June 25, 2011 at 11:50 pm

#1344180
RE: need help for my query to get the number pattern.

Let's put a slightly different slant on this problem and make it super simple in the process. 🙂 Compare the complexity of the While Loop and CTE solutions...
--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)

June 25, 2011 at 11:31 pm

#1344178
RE: need help for my query to get the number pattern.

jkp2311 (6/25/2011)
Hi Jeff,
I am so Sorry...
it was my mistake...
i apolozige to you...
Accepted and much appreciated. We're good.
Shifting gears, the reason why I keep asking why you want to do...
--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)

June 25, 2011 at 11:15 pm

#1344176
RE: Running Total by recursive CTE only works right on the first two rows??

That's a fairly small number of rows. Be advised that you have a time-bomb ticking in your first query.
AND CAST(net AS INT) / 100 > 0
I'm pretty...
--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)

June 25, 2011 at 10:22 pm

#1344175
RE: Author Guidelines

Fine! I'll take the last word. 😉 No one has or is denying you your personal opinion. I say, again, that you did a great job...
--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)

June 25, 2011 at 9:46 pm

#1344174
RE: Running Total by recursive CTE only works right on the first two rows??

That still doesn't say much about the performance, Drew. How many rows are you processing with this and about how long does it take? 🙂
--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)

June 25, 2011 at 5:34 pm

#1344165
RE: Author Guidelines

ark.trofman (6/25/2011)
Well, obviously, your perception of the article differs from mine. I expressed my opinion, you - yours. From your point of view my comment was not necessary, from mine...
--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)

June 25, 2011 at 5:31 pm

#1344164

Viewing 15 posts - 33,466 through 33,480 (of 59,099 total)