Jeff Moden

Forum Replies Created

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

RE: SQL Query not running...

A Little Help Please (3/9/2009)
Somthing strange is happening?!
I have restored a SQL 2000 DB on to a new SQL 2005 DB.
When I run:
select top 100 * from tbldeals
order by trade_date...
--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 9:07 pm

#956534
RE: How to select data in t-sql

jmucherla (3/9/2009)
Hi,
My table structure is like this.
TABLE: TEST
ID countries
100 IN, AU, GB, FR
101 GB, FR, IN
102 ...
--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 8:46 pm

#956526
RE: decrypting table contents

Shahrukh Khan (3/9/2009)
Our application developer/consultant encrypted them in the application.
So no problem, right? Just ask that person for the encryption key. If (s)he doesn't give it to you,...
--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 8:36 pm

#956522
RE: Are the posted questions getting worse?

Heh... don't be sorry that you don't see it... be glad.
--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 8:33 pm

#956520
RE: Are the posted questions getting worse?

RBarryYoung (3/9/2009)
However, the most important thing to remember is that they ARE a small minority of the folks that we see and help.
And, finally, the thread devours itself...
--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:54 pm

#956505
RE: Tune Stored Proc

Mike Levan (3/9/2009)
Jeff
Probably 1 hr for each step.
thanks
As the others have suggested, there's something wrong with that picture, Mike, and we probably won't be able to help from here.
First, check...
--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:34 pm

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

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