Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,546 through 43,560 (of 59,097 total)

RE: buld a rule with Numeric chars only

Lowell,
The answer to your +- problem is that if you wish to include the dash in the pattern, it's easiest to do if you list it first so that it'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)

June 8, 2009 at 11:37 am

#1006203
RE: buld a rule with Numeric chars only

Carl Federl (6/8/2009)
Perhaps I am missing something, but what is wrong with the system function "isnumeric" ?
CREATE RULE [dbo].[NumericCharsOnly]
AS
ISNUMERIC(@value) = 1
GO
Here's one of many problems with ISNUMERIC...
--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 8, 2009 at 11:35 am

#1006201
RE: What SQL Server Sites do you use?

Heh... after reviewing the FAQ for StackOverflow, I have a couple of problems with that site... first, they want you to be both honest and nice. Most people interpret...
--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 7, 2009 at 9:28 pm

#1005899
RE: Sum of top n rows

Sergiy (6/7/2009)
Jeff Moden (6/6/2009)
Amazing... what the hell did the boys in Redmond do? The code posted above by arijit works just dandy in 2k5. The error appears when...
--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 7, 2009 at 9:11 pm

#1005897
RE: Generating records without using cursor

lmu92 (6/7/2009)
I was wondering about his reply too, since the two statements (regarding the article and the correlation to the original subject) within one post don't seem to match up...
--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 7, 2009 at 9:01 pm

#1005896
RE: Generating records without using cursor

RBarryYoung (6/7/2009)
Jeff Moden (6/7/2009)
Indu (6/7/2009)
I have gone through the example
Heh... is it just me or does that really sound pompous and arrogant? 😉
No, i wouldn't say that it was pompous...
--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 7, 2009 at 8:43 pm

#1005894
RE: QueryTo Get All Scripts

Do a search for the old ScptXfr.exe code that used to come with SQL Server 2000. Rumor has it that it works well with SQL Server 2005 but I've...
--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 7, 2009 at 8:38 pm

#1005893
RE: Dates Between From date and To Date

Well done one and all, but there is no need for such complex solutions.
INSERT INTO dbo.tbl_Destination
(EmpNo, TheDate, Project)
SELECT s.EmpNo, DATEADD(dd,...
--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 7, 2009 at 3:26 pm

#1005870
RE: Generating records without using cursor

Indu (6/7/2009)
I have gone through the example
Heh... is it just me or does that really sound pompous and arrogant? 😉
--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 7, 2009 at 3:02 pm

#1005867
RE: need help -- tempdb full message, but its only 8 mb in size

Mike (6/7/2009)
the db is set to unrestricted growth and has been, so that's not it.
Stupid question, then. Are you sure you're looking at the correct server? TempDB...
--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 7, 2009 at 2:55 pm

#1005863
RE: What SQL Server Sites do you use?

Doc (6/7/2009)
Lynn Pettis (6/5/2009)
I am curious, which sites do you use or frequent either asking for help or helping others?
I don't use them, I'm just regularly visit them all, forums...
--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 7, 2009 at 12:55 pm

#1005852
RE: sql server error

Brainy,
Gail's answer is the method I use if I have to do something like this (rare, usually wrong thing to do, but sometimes similar thing correctly happens on maintenance scripts)....
--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 7, 2009 at 12:40 pm

#1005850
RE: charindex help

Thanks for the awesome feedback, John. I really appreciate it.
Thanks for including an explanation, as well. I normally try to explain the code for the OP in the...
--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 6, 2009 at 6:44 pm

#1005762
RE: Are the posted questions getting worse?

David Burrows (6/6/2009)
But more time for the deflected rebound to smack you in the face 😛
BWAA-HAA!!! There in lies the secret... you have to learn how to catch them...
--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 6, 2009 at 4:29 pm

#1005761
RE: Are the posted questions getting worse?

Yep... found it that way in 2k5, as well, just like Paul said. As Gail pointed out, they still haven't said anything explicit about using a table alias as...
--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 6, 2009 at 1:50 pm

#1005756

Viewing 15 posts - 43,546 through 43,560 (of 59,097 total)