Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,271 through 48,285 (of 59,099 total)

RE: multiple LEFT OUTER self joins and a View

ishmael (9/17/2008)
Re: Peso - this is a clever and quick way of doing it, and works well (needs a GROUP BY PartyID at the end) - however will demand significant...
--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)

September 17, 2008 at 8:04 pm

#873347
RE: Stored procedure moving dates.

You might want to consider using 4 digit years and, possibly, a date format where the month and day cannot be confused... for example, is 06/07/2008 June 7th or July...
--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)

September 17, 2008 at 8:01 pm

#873345
RE: Error while importing data in a empty table

Google search turned up about a million hits on this error. Here's the KB article from Microsoft that turned up...
http://support.microsoft.com/kb/225782
--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)

September 17, 2008 at 7:53 pm

#873344
RE: converting text to int

You're welcome. How did you find the bad data?
--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)

September 17, 2008 at 7:48 pm

#873342
RE: Nested Cursors

Thanks, Lynn.
Scott, the article is long because it explains the wrong way to do things as well as the right way. The concept is wicked simple and creating running...
--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)

September 17, 2008 at 7:38 pm

#873339
RE: Add space to a database a little at a time or large chunk?

I concur... basically, auto-growth should never take you by surprise... it should be a planned event and it should be made based on a plan derived from usage patterns. ...
--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)

September 17, 2008 at 7:31 pm

#873337
RE: data error in cursor

joshua.a.anderson (9/17/2008)
wow i'm an idiot. thanks for your help. to bad there is not some gift card service to give to bulletin board members for good help.
LOL! PayPal always...
--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)

September 17, 2008 at 7:13 pm

#873335
RE: Keep first row in grouped data

In that case, please take a peek at the link in my signature. It'll help use help you faster and better. 😉
--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)

September 17, 2008 at 7:10 pm

#873334
RE: Multiple update statements in a script

Triple posted... please click on the user's name to find the other 2.
This is a huge waste... splits the answers to a single problem into 3 different posts. Please...
--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)

September 17, 2008 at 7:07 pm

#873332
RE: Please help: Multiple update statements in a script

Triple posted... please click on the user's name to find the other 2.
This is a huge waste... splits the answers to a single problem into 3 different posts. Please...
--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)

September 17, 2008 at 7:07 pm

#873331
RE: Need help from t-sql experts

Triple posted... please click on the user's name to find the other 2.
This is a huge waste... splits the answers to a single problem into 3 different posts. Please...
--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)

September 17, 2008 at 7:06 pm

#873330
RE: SQL Spelling mistakes

Yeaup... test the first sproc you changed before you promulate the change to 199 others. Simple testing is the best verification tool there is. And, in this case,...
--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)

September 17, 2008 at 7:00 pm

#873327
RE: converting text to int

Jeff (9/17/2008)
I did try that first. It gives the error:
Server: Msg 235, Level 16, State 1, Line 1
Cannot convert a char value to money. The char value has incorrect...
--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)

September 17, 2008 at 6:53 pm

#873323
RE: Keep first row in grouped data

As so many will, undoubtedly, tell you, how do you know what the "first" record really is? There's no guarantee that the order you enter the data will stay...
--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)

September 17, 2008 at 6:35 pm

#873320
RE: Databases for Change

Great article and very well presented as JJ B and a couple of others noted.
I take no offense to building a database of lobbyists, etc... but instead of spending good...
--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)

September 17, 2008 at 6:24 pm

#873318

Viewing 15 posts - 48,271 through 48,285 (of 59,099 total)