Jeff Moden

Forum Replies Created

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

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
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

alen teplitsky (12/15/2010)
string formatting is one of my least favorite things to do. it can take hours to get things right which is a waste of time in my opinion.
which...
--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:18 pm

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

Tom Bakerman (12/15/2010)
Nice article Jeff. You would think, that after all this time, some computer scientist somewhere would come up with a decent way to deal with 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)

December 15, 2010 at 9:14 pm

#1263278
RE: Are the posted questions getting worse?

Heh... I just can't keep up. It would appear you folks found the thread we were talking about.
BTW... I don't use FLOAT anymore either. Too many people were...
--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:00 pm

#1263276

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