Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,876 through 49,890 (of 59,099 total)

RE: TAB

It depends... we don't really know enough about what you're trying to do to tell you whether you're headed in the right direction or not...
--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 20, 2008 at 7:31 am

#831753
RE: Update of text field removing Cr Lf

If you're looking at it in the grid mode, then it will look as if the CrLf's are blanks... try looking at it in the text mode.
--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 20, 2008 at 7:24 am

#831742
RE: Create Temporary Tables Dynamically in cursor loop

Yeah... I'm afraid I'm a bit guilty there, as well.
elmerbotha... Chris Morris (posted above) thought that you might have more than 1 data point for each UoM for each Metal......
--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 20, 2008 at 7:20 am

#831735
RE: Fast way to create temp table from existing table definition

Let us know how the tests work out... even if it's just confirmation but especially if you find something new or different. 🙂
--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 20, 2008 at 7:09 am

#831730
RE: Create Temporary Tables Dynamically in cursor loop

rbarryyoung (6/20/2008)
Try this:
SELECT Metal, min(Result), max(Result), count(Result), stdev(Result)
FROM Metals
GROUP BY Metal
By the way, stdev() is the statistical standard deviation, if you want the standard deviation for a population...
--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 20, 2008 at 7:07 am

#831727
RE: Best Practices for Database Design

Grant Fritchey (4/6/2005)
Naming standards are very good things. Common abbreviations are very good things.
Very good things can, however,be taken to silly extremes. We've got a logical modeling team tasked 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)

June 20, 2008 at 6:17 am

#831692
RE: Best Practices for Database Design

Markus Engelhardt (4/6/2005)
and if you try to insert something into a view the error that will pop up will clearly explain the difference.
Ummm.... what makes you think you can't insert...
--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 20, 2008 at 5:33 am

#831656
RE: Fast way to create temp table from existing table definition

Ohhh... Sorry KG... my comments weren't directed at you personally...
I've even seen some of the big dogs in SQL perpetuate such myths and that was my point to everyone....
--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 20, 2008 at 5:22 am

#831644
RE: Create Temporary Tables Dynamically in cursor loop

Oh yeah... almost forgot... if you'll leave the flippant attitude and sarcasm at home and post the code that produces your result set, we can also show you how 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)

June 20, 2008 at 5:12 am

#831636
RE: Create Temporary Tables Dynamically in cursor loop

elmerbotha (6/20/2008)
I truly feel honored to be graced by your absolutely meaningful and relevant answers. Truly, I am astounded by your infinite wisdom. Without risking being ridiculed once again by...
--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 20, 2008 at 5:08 am

#831633
RE: Create Temporary Tables Dynamically in cursor loop

Heh... I'm just not good at diplomacy when I see people trying to commit "Death by SQL". It's just absolutely impossible to pick up a turd by the clean...
--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 19, 2008 at 2:25 pm

#831421
RE: Split text by empty spaces

GSquared (6/19/2008)
Jeff, he's not looking to parse out the whole string. Just grab the second word, and everything else.
String parser was my first thought too, but then I read...
--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 19, 2008 at 2:21 pm

#831417
RE: How to update different column depends on seq

Suppressing... urge... to... load... porkchops... on... OP...
PLEASE! You haven't read the article that everyone has been asking you to... let's try this one final time... read,...
--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 19, 2008 at 2:08 pm

#831405
RE: Interview Questions for Reporting Services

How do you format dates, times, and currency?
How do you display grouped running totals?
How do you schedule reports for nightly runs?
How do you create a spreadsheet report? An HTML...
--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 19, 2008 at 1:55 pm

#831391
RE: Concatenating Field Values

Perhaps you can modify the following technique... dunno if it'll actually work in Reporting Services but, rumor has it that you can make queries and functions part of the works...
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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 19, 2008 at 1:35 pm

#831371

Viewing 15 posts - 49,876 through 49,890 (of 59,099 total)