Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,701 through 44,715 (of 59,095 total)

RE: How to handle empty return

john.clyma (3/9/2009)
Jeff,
Thanks for the response! I have used 'If exists(blah)' in the past, it slipped my mind. Is there a way to mark the post as 'complete' or...
--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:24 pm

#956500
RE: Generate UNIQUE VARCHAR Identifier?

UB (3/9/2009)
Like I pointed out in the example, the value in ID column doesn't necessarily have t match the integer value in the 'VARCHAR ID' column
So, after 2 weeks, have...
--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:14 pm

#956498
RE: Group By clause

My favorite trick to resolving most of the problems stated in this thread is to do a pre-aggregation in a Temp Table and go from there. It limits performance...
--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:09 pm

#956497
RE: What Does Support Look Like?

t.walker (3/9/2009)
SQL Server 2000 is fine for stuff written in the days of SQL Server 2000.
The basic point here is 'if it broke don't fix it'. If it is broken...
--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 5:59 pm

#956492
RE: Urgent : Sql server db tuning

jparker2 (3/9/2009)
I have seen this issue with any code, and any variation of Oracle Versus SQL ever since the first Java interface for ODBC drivers was released.
It can 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 9, 2009 at 4:41 pm

#956468
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

Chris Morris (3/9/2009)
Jeff Moden (3/7/2009)
Actually, in SQL Server 2k5, we don't need to solve the running total problem for this because it's just a ranking problem... this should do...
--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:34 pm

#956464
RE: BCP Format File

Yep... no need for the extra column...
SET @bcpcommand = 'bcp "SELECT ''"''+title,forename,surname,pafad1,pafad2,pafad3,pafad4,pafad5,pafad6,postcode,urn,emailaddress from ASHLEY.DBO.tablename" queryout c:\work\ashtest.txt -f c:\work\bcpformatfile.fmt -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)

March 9, 2009 at 4:29 pm

#956462
RE: BCP PROBLRM

arasan_lotus (3/9/2009)
hai..
actually I am new in sqlserver,
EXEC JPCFHONYVLDATA..xp_CmdShell 'Dir C:\'
when i execute above code ,I got "Could not locate entry in...
--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:24 pm

#956459
RE: Are the posted questions getting worse?

Bob Hovious (3/9/2009)
Yes, I remember that article. I'm old school, in that I think trust is something that has to be earned. It shouldn't be 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)

March 9, 2009 at 4:18 pm

#956455
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

Viewing 15 posts - 44,701 through 44,715 (of 59,095 total)