Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,671 through 35,685 (of 59,102 total)

RE: datetime to month - year

andell_ramsay (12/15/2010)
Jeff -
How then would one be able to sort chronologically on this field? Is there a way to keep the format while changing the data type to 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)

December 16, 2010 at 7:10 am

#1263438
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

For all you relatively new folks, I thought I'd help you head off a future problem if you ever need to ask a T-SQL or Performance related question either on...
--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)

December 16, 2010 at 7:05 am

#1263433
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

Nakul Vachhrajani (12/16/2010)
Thank-you, Jeff! Great series!
Thanks, Nakul... I appreciate 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)

December 16, 2010 at 6:57 am

#1263425
RE: SPLITTING A STRING

hemanth T (12/16/2010)
hi,
thanks for your advice.surely i will not use caps hereafter,and also thank you for the solution u gave to my scenario.:-)
Thanks for the feedback, hemanth. 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)

December 16, 2010 at 6:55 am

#1263423
RE: query to get all childs and grand children for a prent

Learner1 (12/10/2010)
I got the answer anyways,,,using Recursive CTE
IMHO... [font="Arial Black"]ABSOLUTELY NOT!!! [/font]:-P
While it certainly is easy to write an rCTE to do this, an rCTE will use a heck 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)

December 15, 2010 at 11:54 pm

#1263314
RE: SPLITTING A STRING

Heh... first... the use of all caps usually ticks people off because it's an indication of yelling on these forums. Just so you know. 😉
Second, I'll let the code...
--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)

December 15, 2010 at 11:50 pm

#1263313
RE: Round to next 1000 or 100 without Ceiling function

There's another disadvantage to using CEILING for this problem... if you divide first using a NUMERIC number such as 1000.0 and the original number was an INT, the result won't...
--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)

December 15, 2010 at 10:24 pm

#1263299
RE: Round to next 1000 or 100 without Ceiling function

andrewd.smith (12/15/2010)
Jeff Moden (12/15/2010)
parthi-1705 (12/13/2010)
But i want to know only CEILING can do this or some other functions can do this or not
Thanks
Parthi
CEILING is the way people do 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)

December 15, 2010 at 10:06 pm

#1263294
RE: SELECT All Columns from a table - without re-engineering if table stucture changes

ASDL (12/15/2010)
Thanks all! This was a good discussion.
My options are Method 2 and Method 3, I'll choose #3 (SELECT * query) because it is simple and AFAIK I would get...
--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)

December 15, 2010 at 9:49 pm

#1263292
RE: How do I know when to use temp tables/table variables?

WayneS (12/15/2010)
[Sigh]
So many people need to see my presentation... maybe at SQL Rally??? I'm counting on you guys to vote for it next month!
[/Sigh]
I absolutely agree with that. Lot'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)

December 15, 2010 at 9:38 pm

#1263287
RE: How do I know when to use temp tables/table variables?

Tom.Thomson (12/15/2010)
Jeff Moden (12/14/2010)I'm not sure I'd call them dangerous (by themselves, they won't cause any damage, I think) but they sure are false. Heh... it's proof positive 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)

December 15, 2010 at 9:37 pm

#1263286
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

jigneshdpatel (12/15/2010)
Is SQL Server Team listening?
Nah... probably not. What's important is that people who use T-SQL everyday are. 🙂
I noticed that this was your first post. Let...
--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)

December 15, 2010 at 9:28 pm

#1263284
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

CirquedeSQLeil (12/15/2010)
Thanks Jeff. This is functionality that I have yet to use.
You bet, Jason, and thanks for stopping by. Hopefully I've given most folks incentive to continue 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)

December 15, 2010 at 9:26 pm

#1263283
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

UMG Developer (12/15/2010)
Like a lot of other people I never even knew of STR(), I have always used CAST/CONVERT with a RIGHT to get the results I needed. But now...
--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)

December 15, 2010 at 9:24 pm

#1263282
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

mtassin (12/15/2010)
I didn't even know STR() existed... when I need to make strings out of numbers I always use cast and convert.
Thanks a lot Jeff... as I said before, 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)

December 15, 2010 at 9:20 pm

#1263280

Viewing 15 posts - 35,671 through 35,685 (of 59,102 total)