Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,716 through 44,730 (of 59,101 total)

RE: Are the posted questions getting worse?

GSquared (3/9/2009)
Grant Fritchey (3/9/2009)
All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.
That is too funny! ...
--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)

March 9, 2009 at 4:16 pm

#956453
RE: BCP Format File

If we can't get this bugger up and running in short order, we'll do the QUOTENAME thing for the export so we don't have to mess with the Format file......
--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)

March 9, 2009 at 6:19 am

#955903
RE: BCP Format File

Heh... dammit... I didn't test it and I forgot about that little nuance... My humble appolgogies...
Here's a new BCP Format file with no "skips"...
9.0
12
1 SQLCHAR 0...
--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)

March 9, 2009 at 6:17 am

#955899
RE: A complicated query (for me)

Yow... sorry Flo... "OP" can mean either "the Original Poster" or the "Original Post" depending on how it's used in a sentance. And, it can also be a bit...
--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)

March 8, 2009 at 6:38 pm

#955763
RE: What Does Support Look Like?

I don't mind so long as MS stops deprecating stuff... that's a bloody killer.
--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)

March 8, 2009 at 6:35 pm

#955762
RE: how can i convert this date'200702071630+1100' in datetime or in string '20070207'

Heh... dangit, Andrew... you beat me to 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)

March 8, 2009 at 6:30 pm

#955759
RE: how can i convert this date'200702071630+1100' in datetime or in string '20070207'

The "+1100" indicates the time zone of the date. You may have to substract that as a number of hours and minutes from the date and that will give...
--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)

March 8, 2009 at 6:28 pm

#955758
RE: How to handle empty return

IF EXISTS(Select 1 from t_Names where id = 1234)
BEGIN
Select isNull(fName, 'N/A') from t_Names where id = 1234
END
ELSE
BEGIN
...
--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)

March 8, 2009 at 6:22 pm

#955755
RE: Questions to ask your clients DBA?

Heh... in cases like this, I believe that being cynical is a healthy thing to do.
I wouldn't isolate the converstation nor the requirements to just the DBA... there may 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)

March 8, 2009 at 6:19 pm

#955754
RE: BCP PROBLRM

Jeffrey Williams (3/8/2009)
I may be missing something - so please correct me if I am wrong, but don't you need to specify which server you are going to connect 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)

March 8, 2009 at 6:07 pm

#955753
RE: Performance Issues

radek (3/8/2009)
Hi I have other question about indexes:-)
I read something about indexes, that indexes is good create in "big table"
But when I create table in MS SQL by GUI 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)

March 8, 2009 at 6:03 pm

#955751
RE: A complicated query (for me)

I agree, Flo... I just want to make sure what the OP means by "Deleted"... sometimes folks just mean "not included in the result set" and I wanted to 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)

March 8, 2009 at 5:16 pm

#955741
RE: Stored Procedure

Those would certainly qualify as "housekeeping" stored procedures. I'm curious... why the question?
--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)

March 8, 2009 at 10:02 am

#955676
RE: Are the posted questions getting worse?

Chris Morris (3/8/2009)
GilaMonster (3/8/2009)
Jeff Moden (3/7/2009)
Consider the OP in the following... Lynn may have competition for saint-hood... 🙂
http://www.sqlservercentral.com/Forums/Topic670491-338-1.aspx
Mike is one of those people on my blacklist, due to his repeated...
--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)

March 8, 2009 at 9:58 am

#955675
RE: Cursors

Heh... even after the typo was repaired, no one got the correct answer because it wasn't listed. The correct answer should be...
"Who cares? Rewrite the code to 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)

March 8, 2009 at 9:31 am

#955672

Viewing 15 posts - 44,716 through 44,730 (of 59,101 total)