Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,071 through 50,085 (of 59,099 total)

RE: Eliminating Cursors

Jim Russell (6/13/2008)
I was getting worried when I got through 5 or 6 pages of this thread and hadn't seen Jeff Moden jumping in to point out that different types...
--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 13, 2008 at 1:35 pm

#828768
RE: Cannot bulk load. Invalid column number in the format file

sharma (6/13/2008)
Thanks for ur reply..
You had changed 1,2,14,37,44 as 1,2,3,4,5
But it is host file field order only.
I have to specify sequence order? Because
i am selecting 1,2,14,37,44 filed from table (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)

June 13, 2008 at 1:18 pm

#828759
RE: DELETE DUPLICATE RECORDS

vinuraj (6/13/2008)
this link is more than enough...
... to bring your server right to it's knee's. It took over 10 minutes to find and delete a lousy 156 rows from...
--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 13, 2008 at 1:15 pm

#828757
RE: Remove Locking from particular row

seenu_61281 (6/13/2008)
thanks madam..i will try this..
one more doubt..
i am using sql 2005 express.i need to insert data from a grid control in vb 6.0. The entries are being done by...
--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 13, 2008 at 12:17 pm

#828721
RE: Which syntax is better and why?

Now, I agree with THAT! That's my favorite format because it puts all of the aliases in the same position horizontally speaking AND it's the same format required by...
--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 13, 2008 at 12:07 pm

#828712
RE: Eliminating Cursors

Bobbie Shrivastav (6/13/2008)
I was able to utilize the proc. This is GREAT. The only thing I had to change was to use a coalesce rather than isnull....
--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 13, 2008 at 12:01 pm

#828705
RE: Using VBA to pull SQL data into Excel?

montgomery johnson (6/13/2008)
I'm using Excel 2003. Do you mean "Import External Data"? Please be more specific. We have many spreadsheets with data imports to more than 10 tabs each. Can...
--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 13, 2008 at 10:38 am

#828658
RE: Eliminating Cursors

dbishop (6/13/2008)
As a rule, I don't like to use them and try to avoid them as the 'easy way out,' but to say you NEVER use them and 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)

June 13, 2008 at 10:26 am

#828653
RE: Eliminating Cursors

Chris.Strolia-Davis (6/13/2008)
while (select count(*) from @table) > 0
begin
select top 1 'do something', @id=id from @table
delete from @table where id=@id
...
--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 13, 2008 at 10:22 am

#828649
RE: Eliminating Cursors

dugsmith (6/13/2008)
thereby not having to wait for the cursor to be deallocated to release its locks.
"Firehose" cursors do not keep the same types of locks... in fact, they're pretty much...
--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 13, 2008 at 10:06 am

#828642
RE: Eliminating Cursors

abhay.kulkarni (6/13/2008)
Creating a table variable is in the memory, not in the tempdb and hence much more efficient.
Absolutely NOT true... please see Q4/A4 in the following URL. In fact,...
--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 13, 2008 at 9:50 am

#828633
RE: Include Column Headers From SSMS

Which service pack are you running?
--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 13, 2008 at 7:40 am

#828487
RE: CSV data import/export via a stored procedure?

Michael Earl (6/12/2008)
OpenQuery will allow you to do this.
Do you have example code of how to use OpenQuery to export to a CSV 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)

June 12, 2008 at 9:13 pm

#828215
RE: Using VBA to pull SQL data into Excel?

Why not use "Get External Data"? Much easier... look it up in Excel Help.
--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 12, 2008 at 9:09 pm

#828214
RE: Cannot bulk load. Invalid column number in the format file

8.0
5
1 SQLCHAR 0 8 "|" ...
--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 12, 2008 at 9:06 pm

#828212

Viewing 15 posts - 50,071 through 50,085 (of 59,099 total)