Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,956 through 44,970 (of 59,101 total)

RE: help

Looks like a final exam to me... who gets the "A" if we answer them?
It's time to hucker down and do you own work... heh... c'mon, it'll be fun! 😉
--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)

February 26, 2009 at 8:28 pm

#950957
RE: Are the posted questions getting worse?

I follow the following casing standard...
All SQL Keywords in UPPER CASE.
All database names, table names, procedure names, column names, column aliases, variable names (basically, my stuff) etc, in MixedCase 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)

February 26, 2009 at 1:26 pm

#950817
RE: Determining the Nearest Record to a Given Location

GSquared (2/26/2009)
Jeff Moden (11/29/2008)
Heh... milliseconds per calculation mean a lot if you have millions of shipments to make.
Actually, difference is microseconds per calculation, but for the sake of argument, let's...
--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)

February 26, 2009 at 1:05 pm

#950794
RE: A Case For Concatenation (Building Delimited Strings ) In T-SQL

Bruce W Cassidy (2/26/2009)
[font="Verdana"]One of the recent (i.e. in the last ten years) changes in data warehousing has been a move away from specialised ETL tools like Informatica, Data Stage,...
--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)

February 26, 2009 at 1:00 pm

#950791
RE: Concatenating Field Values

mark_92708 (2/26/2009)
Hi all,
I was reading this thread because I was looking for a solution to this identical problem - trying to concatenate the result strings of one field from 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)

February 26, 2009 at 12:42 pm

#950777
RE: transpose row to columns

Yep... it's call a "Cross-Tab" or "Pivot"... and the type of table you have is called an "NVP" or "Name/Value Pair" table...
SELECT ID,
...
--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)

February 26, 2009 at 5:46 am

#950532
RE: Can any one tell me?

saravanantvr1984 (2/26/2009)
how can we convert date(2009-02-26) format to this format Twenty-Second May Nineteen Nineteen Eighty Two?
is it possible in 2000/2005?
I can understand maybe doing this on numbers for a check...
--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)

February 26, 2009 at 5:28 am

#950520
RE: Are the posted questions getting worse?

Derek Dongray (2/26/2009)
Roy Ernest (2/25/2009)
We could have a thread here that fights out the best practice list and we can provide a final list to the Newbies. 😀
Then someone could...
--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)

February 26, 2009 at 5:05 am

#950513
RE: csv file upload

I believe you can use a UNC there so the file can be on another machine other than the server. But, whatever login the server uses, it must 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)

February 26, 2009 at 12:10 am

#950435
RE: help get all month Day of the Week like calendar

... and, can it be an inline bit of code or do you really need it as a function?
--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)

February 26, 2009 at 12:06 am

#950434
RE: help get all month Day of the Week like calendar

gpspocket (2/25/2009)
how to do this ??
mydate= 02/2009
and get like this
fld1 |fld2 |fld3 ...
--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)

February 25, 2009 at 11:24 pm

#950429
RE: Any way to hide column names from result set?

n_parker (2/25/2009)
The datatype is nvarchar(20) for the partnumber and nvarchar(100) for the description - so this works perfectly: SELECT PartNumber + ',' + Description EXCEPT that it has...
--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)

February 25, 2009 at 11:07 pm

#950428
RE: Are the posted questions getting worse?

RBarryYoung (2/25/2009)
Jeff Moden (2/25/2009)
I'm going to give up my formatting habits on this forum... from now on, I'm going to post all code with no comments, all upper case, 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)

February 25, 2009 at 10:54 pm

#950427
RE: Are the posted questions getting worse?

Hey! By the way, Steve... is there a way to enforce a max width limit on the code windows? Say, at 120 characters so when some of these...
--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)

February 25, 2009 at 9:23 pm

#950401
RE: Are the posted questions getting worse?

Steve Jones - Editor (2/25/2009)
Sorry, Jeff, had to edit that one. Boy that's annoying when someone does that.
Speaking of which....maybe I should make it a development priority to automatically format...
--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)

February 25, 2009 at 9:12 pm

#950397

Viewing 15 posts - 44,956 through 44,970 (of 59,101 total)