Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,811 through 42,825 (of 59,102 total)

RE: sql query

TAman (7/23/2009)
Can anyone send me code that would get me my expected result above based on the data below?
Heh... oh yeah... someone will post code that will solve 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 23, 2009 at 1:41 pm

#1029249
RE: Are the posted questions getting worse?

Grant Fritchey (7/23/2009)
Another completely off-topic post.
My 11 year old is starting to discover books (YAY! Finally). He just tore through Zelazny's "Damnation Alley." I need more in this vein. Any...
--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 23, 2009 at 1:27 pm

#1029237
RE: Are the posted questions getting worse?

RBarryYoung (7/23/2009)
You could 1) drink too much
Heh... NOT possible... 😛
--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 23, 2009 at 1:23 pm

#1029234
RE: Are the posted questions getting worse?

GilaMonster (7/23/2009)
They believe that free houses, electricity and water are their right.
Heh... future project managers? 😛
--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 23, 2009 at 1:19 pm

#1029232
RE: Problem with Query

This is a fairly complex problem for those that don't know how to solve it and I wouldn't be surprised if no one on Chandra's side of the house tried...
--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 23, 2009 at 1:10 pm

#1029226
RE: Create CSV file using sp_send_dbmail with field delimiters

Cool... thanks for the feedback, Steve.
--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 23, 2009 at 1:05 pm

#1029225
RE: Query to rebuild/reorganize all indexes in the database?

John Mitchell (7/23/2009)
Jeff Moden (7/21/2009)
Heh... don't over look what's in Books Online. If you lookup "DBCC SHOWCONTIG" and scroll down, you'll find a section with the following label...
[font="Arial Black"]E....
--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 23, 2009 at 1:05 pm

#1029224
RE: DBA's and Developers

Steve Jones - Editor (7/23/2009)
One small addition. I'd make sure they all use their Windows account, not SA, to make changes. It will help them to be respectful towards each...
--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 23, 2009 at 12:59 pm

#1029221
RE: sql query

smunson (7/23/2009)
There's a logic problem here...
...but clearly, that 3rd entry is within 60 minutes of the 2nd entry
Heh... Glad I'm not the only one... That's exactly the point I was...
--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 23, 2009 at 12:51 pm

#1029214
RE: Passing Stored Procedures "values" for IN

head_contusion (7/23/2009)
I am really tired because my 1 yr. old woke me really early this morning.
I'm looking through the suggested solutions to this problem, and I'm not understanding them....
--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 23, 2009 at 12:45 pm

#1029203
RE: differiniate quotes as data vs quotes as column identifier

Ghanta (7/23/2009)
Hey Jeff,
Thanks a lot for your response. I tried that and I got this error:
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
I am running this on:
Microsoft SQL Server...
--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 23, 2009 at 12:33 pm

#1029191
RE: How do I change the structure of a table with data in it?

FredS (7/23/2009)
I just tried to change a table. I selected a column that was char(35) and changed it to char(36), and pressed Save.
"Saving changes is not permitted. The...
--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 23, 2009 at 5:49 am

#1028871
RE: Are the posted questions getting worse?

jcrawf02 (7/22/2009)
Someone at work put this in their sig, which instantly made me want to "accidentally" spill hot coffee on them . . . thought the gang would enjoy
"He 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 22, 2009 at 11:42 pm

#1028768
RE: Are the posted questions getting worse?

. (7/22/2009)
If you're going to tell them they're not posting right then it would be a good idea if you could give them the link to the information about the...
--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 22, 2009 at 11:34 pm

#1028767
RE: Problem with Query

. (7/22/2009)
Matt and Lynn,
I'll go ahead and send you my solution, so you can double-check me. I did it with CTEs and freely admit there is probably...
--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 22, 2009 at 11:28 pm

#1028766

Viewing 15 posts - 42,811 through 42,825 (of 59,102 total)