Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,731 through 38,745 (of 59,098 total)

RE: Bulk Update from Text file

Actually, OPENROWSET requires the data to be fairly solid. True that it's more forgiving than BULK INSERT and BCP especially when it comes to how the first row 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)

April 26, 2010 at 7:03 am

#1157577
RE: Passing a Table to A Stored Procedure

Carlos Shoji-387174 (9/23/2007)
Very good article!
Is there any way to do a similar thing with SQL Server 2000?
Thanks.
Kind of... Please see the following article with the understanding that it's limited 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)

April 26, 2010 at 6:57 am

#1157573
RE: To reduce CPU cost being used by SORT

The following two items in your code above...
and a.root_claim_id < b.root_claim_id --original claim ID is less than the duplim ID
and a.claidate <= b.cl_date --original received before duplicate received
... probably consitute...
--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)

April 26, 2010 at 6:51 am

#1157566
RE: How To Get Last Inserted Record Value In SQL Server

Vijay Sinha (4/25/2010)
How To Get Last Inserted Record Value In SQL Server
The table have no Primary key, identity, it have only one column "Name"(Column Name)
Without either a date column 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)

April 26, 2010 at 6:42 am

#1157562
RE: Are the posted questions getting worse?

chandrashekarthota (4/26/2010)
As a site administrator I request you to kindly ignore my Core member comments. I am
closing down my site for few weeks just because of plagiarism and I have
learned...
--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)

April 26, 2010 at 6:23 am

#1157556
RE: Minimal Meetings

david.wright-948385 (4/26/2010)
Very true. It's worth pointing out the proportion of time spent on meetings from time to time.
Anyone else here find themselves keeping the meeting on track, identifying milestones,...
--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)

April 26, 2010 at 6:14 am

#1157551
RE: Using OPENROWSET to import CSV files

ColdCoffee (4/24/2010)
Thanks, Jeff, for posting your approach.. As i dont have SSMS at home, i will check out your code tomorrow and let you know..
But i got a doubt...
--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)

April 25, 2010 at 10:48 am

#1157409
RE: Substring Function in Where Clause

eseosaoregie (4/23/2010)
Thanks jeff. Will try it this weekend and let you know how it runs. Much appreciated
Since you PM'd me several times on the subject and half the weekend has...
--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)

April 24, 2010 at 6:24 pm

#1157359
RE: dateDiff question

SQL_NuB (4/21/2010)
Jeff Moden (4/19/2010)
SQL_NuB (4/19/2010)
that is setup for the start date or end date begin on a weekend, I need to find out if the day between my two dates...
--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)

April 24, 2010 at 6:20 pm

#1157358
RE: Speed improvement help needed for large xml queries

lmu92 (4/24/2010)
@jeff: it's not that I'm actually advertising XML, I'm sure not. 😉
I just had to get used to it in order to get those "man in the middle" out...
--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)

April 24, 2010 at 5:45 pm

#1157357
RE: Using OPENROWSET to import CSV files

I put the OP's files in C:\Temp to have the following code run...
--DROP TABLE #Staging,#Header,#Data
--GO
--===== Supress auto display of rowcounts
SET NOCOUNT ON;
--===== Declare local variables
DECLARE @pFullPath...
--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)

April 24, 2010 at 5:38 pm

#1157354
RE: Using OPENROWSET to import CSV files

ColdCoffee (4/24/2010)
I am also quite interested in GSquared's import to temp table solution, i will give a shot at this in some time!
BWAA-HAA!!! Try it on the Sample2.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)

April 24, 2010 at 3:42 pm

#1157341
RE: CROSS TAB Query Question.

keyun (4/24/2010)
Imu92 & Rob,
Here is my sample code where i found out how to do cross tab by using 92's suggestion on RoW_NUMBER() function.
DROP TABLE ##TBL1
CREATE TABLE ##TBL1
(Accountvarchar(20),
Prod_codenumeric(18,0),
AmountMoney
)
INSERT INTO...
--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)

April 24, 2010 at 2:49 pm

#1157339
RE: Is there a function which determines if a varchar is a number?

Edward-445599 (11/3/2008)
Hi is there a function which determines if a varchar is a number?
E.g.
Select * from table where filed <> to a number
Let's ask a question here... is the...
--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)

April 24, 2010 at 2:42 pm

#1157338
RE: Financial Data in the Cloud?

I equate "Cloud Storage" to child care... who in their right mind would give their kids to someone they've never met and send them to a place they don't know...
--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)

April 24, 2010 at 2:34 pm

#1157337

Viewing 15 posts - 38,731 through 38,745 (of 59,098 total)