Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,096 through 37,110 (of 59,098 total)

RE: Convert CSV values in three columns to rows

Quatrei.X (8/27/2010)[hrCool! thanks, I needed this... uhmmm, I have a question about this but in a different forum/section (don't wanna double post)...
http://www.sqlservercentral.com/Forums/Topic975437-392-1.aspx?Update=1
hope you can look at it.
Thanks in advance!...
--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)

August 27, 2010 at 6:53 pm

#1213351
RE: CTE - How to surpass the limit

steveb. (8/26/2010)
Quatrei.X (8/26/2010)
hmmmm...
:hehe: I was planning to create a generic function which gets a comma separated list of words in a string and use CTE to seperate those strings...
--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)

August 27, 2010 at 6:50 pm

#1213350
RE: CTE - How to surpass the limit

ColdCoffee (8/27/2010)
Quatrei.X (8/27/2010)
Question 1:
Use tally table or CTE... which is a better practice? (although I'm already thinking of CTE but still wanna hear from you guys)
Jeff Moden's CTE in his...
--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)

August 27, 2010 at 6:43 pm

#1213348
RE: CTE - How to surpass the limit

GilaMonster (8/27/2010)
Quatrei.X (8/27/2010)
Query costs relative to batch is 84% for the first one and 16% for the second.
Those costs are estimates. There are lots of things that make the estimates...
--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)

August 27, 2010 at 6:33 pm

#1213347
RE: CTE - How to surpass the limit

shield_21 (8/27/2010)
Hi there,
Here's another method for splitting comma separated values using recursive cte without using tally table.. When the string contains more than 8000 characters, this performs quite faster (otherwise...
--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)

August 27, 2010 at 6:29 pm

#1213346
RE: If You Had To Pick a Super Hero...

David in .AU (8/27/2010)
Jeff, that's such a cop out 🙂
Come on, show the color of your spandex...
As for me, Atomic Robo, has a lot more fun with technology that 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)

August 27, 2010 at 5:12 pm

#1213340
RE: Missing sequence number

Ram:) (8/27/2010)
Jeff,
Yes, Here the purpose is I will get bill_ids as a string from application.. I want which id's are missing in between.. Just for reporting Purpose which we are...
--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)

August 27, 2010 at 5:10 pm

#1213339
RE: Missing sequence number

Mark-101232 (8/27/2010)
WayneS (8/27/2010)
Jeff Moden (8/26/2010)
I'm waiting to hear back from the OP of what he wants to do if a couple of million row were to be returned because 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)

August 27, 2010 at 5:09 pm

#1213338
RE: If You Had To Pick a Super Hero...

I try to stick with the real life super heroes. Steve Jones comes to mind. I also see a bunch of dedicated heavy hitters on this forum 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)

August 26, 2010 at 11:47 pm

#1212746
RE: xp_cmdshell PSCP - "The server''s host key is not cached in the registry"

akhilesh.aggarwal123 (6/2/2010)
James Rizzo you rocks!!!
I just registered to thank you!!!:-D
That's a cool thing 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)

August 26, 2010 at 11:38 pm

#1212739
RE: The Semantics of NULL in SQL Server 2008

Alex-668179 (8/26/2010)
AFAIK, NULL is the only way to leave a field empty!
I disagree: setting a field to NULL does not 'leave [or make] a field empty', instead it makes (or...
--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)

August 26, 2010 at 11:36 pm

#1212738
RE: XP_cmdshell DIR

Ness (8/26/2010)
SSIS?
To the best of my knowledge, SSIS doesn't have anything to get file sizes. You'd need to write a script of do a bit of an add 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)

August 26, 2010 at 11:31 pm

#1212733
RE: XP_cmdshell DIR

chrs-513176 (8/26/2010)
This gives me what I need. Thanks for the help Jeff!
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)

August 26, 2010 at 11:28 pm

#1212732
RE: Dates from Calendar control

Riskworks (8/26/2010)
Thanks Jeff. You solution is more elegent
Yep, you are right. I meant to subtract a mi or even ss which would work as well to get right...
--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)

August 26, 2010 at 11:24 pm

#1212727
RE: Missing sequence number

WayneS (8/26/2010)
Jeff Moden (8/26/2010)
drew.allen (8/25/2010)
This is not a complete solution. It SEEMS to work here, because all of the gaps in your sample data are one ID. If...
--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)

August 26, 2010 at 11:17 pm

#1212724

Viewing 15 posts - 37,096 through 37,110 (of 59,098 total)