Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,056 through 35,070 (of 59,099 total)

RE: fastest way to export from Oracle into textfiles

sqlgreg (2/14/2011)
I'm working with some Oracle 9i database servers, and I need to export some fairly large tables from Oracle into textfiles.
I'm looking to get all the data at...
--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)

February 14, 2011 at 6:47 pm

#1286818
RE: Database Integrity Job is failing

I believe that the error message says it all...
Windows NT group/user 'sa',
I'm not a systems DBA so not 100% sure but there is probably no user or group called "SA"...
--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)

February 14, 2011 at 6:39 pm

#1286817
RE: Check and validate every value of a subquery

Ok... I'll be the one to ask...
Why not validate and mark all the failures at once using set based SQL? Then you could actually create a report instead of...
--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)

February 14, 2011 at 6:35 pm

#1286815
RE: Compare two table

Ah... first problem I see...
Why are the "empty string" inventory numbers in the Inventory table? Without a proper inventory number on those rows, the amounts mean nothing.
--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)

February 14, 2011 at 6:24 pm

#1286814
RE: Compare two table

Wow! First time user who obviously read the "Forum Etiquette" article. Very well done! I'm surprised people didn't jump all over this with solutions.
Lemme study...
--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)

February 14, 2011 at 6:19 pm

#1286811
RE: Careful Blogging

I ran across this article on potential legal isues with blogs. It doesn't appear the courts have been involved yet, but I'm sure it's coming. At some point there will...
--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)

February 14, 2011 at 6:17 pm

#1286810
RE: How to summarise, listing on same line

Use FOR XML PATH to concatenate the data. If you want a coded answer, take a peek at the article at the first link in my signature line below...
--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)

February 14, 2011 at 6:11 pm

#1286809
RE: Text file i/o from within T-SQL

RaiderX (2/13/2011)
Does anyone know of a book that has a detailed and decent section on file i/o from within t-sql? I'm involved in a project that needs to both...
--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)

February 14, 2011 at 6:06 pm

#1286807
RE: Text file i/o from within T-SQL

Gosta Munktell (2/14/2011)
Why not continue to use C# in combination with ADO and T-SQL.
I use VB.net as an "old" programmer in stead of SSIS.
Let us know how...
--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)

February 14, 2011 at 6:01 pm

#1286806
RE: removal of commas at end

S_Kumar_S (2/14/2011)
Thanks for trying it. Actually the variable @test-2 you have used, is actually a very long select clause in my case (100 lines to be precise). So every time...
--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)

February 14, 2011 at 5:59 pm

#1286805
RE: Counter of characters

Lisset (2/14/2011)
Hi everybody, I want to count all characters(numbers, letters) from my table...someone know the way of do it this.
Thanks for your help!
What do you want to count for things...
--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)

February 14, 2011 at 5:55 pm

#1286804
RE: Cursor and case function

I guess my other question would be, what happens when there are more than 8 permits?
--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)

February 14, 2011 at 5:52 pm

#1286803
RE: xp_cmdshell not supported in SQL 2005 Express Edition

Are you sure you're not using CE?
--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)

February 14, 2011 at 4:46 pm

#1286799
RE: Get Table by name

k.thanigaivel (2/14/2011)
use sp_executesql it will help you.
I'm fairly certain that you cannot use sp_executesql in a function, if that's what you meant. The only thing you can exec 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)

February 14, 2011 at 4:33 pm

#1286798
RE: How To Work with Files based on file name patterns

YSLGuru (2/14/2011)
GOTCHA #1: The process we use to download an d import is proprietary and can not be altered so we can't simply not download the few files we don'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)

February 14, 2011 at 4:27 pm

#1286795

Viewing 15 posts - 35,056 through 35,070 (of 59,099 total)