Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,101 through 47,115 (of 59,095 total)

RE: Update Table based on Sum()

Christopher Stobbs (11/20/2008)
Thanks Jeff,
Very useful info there 🙂
You bet, Chris... thanks for the feedback.
--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)

November 20, 2008 at 6:02 pm

#901362
RE: Update Table based on Sum()

riverswillbeer (11/20/2008)
Wow ... that would suck !! I thank you for the correction. I obviously try to solve the issue using web resources and trial...
--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)

November 20, 2008 at 5:59 pm

#901360
RE: Bulk Insert Grief

Jim Russell (11/20/2008)
Jeff: did your "awesome idea" involve something other than BULK INSERT?
Combination of that and "something else". Dunno if it'll be worth it, but wanted to give 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)

November 20, 2008 at 5:46 pm

#901358
RE: How to minimize processing time when using a cursor

You already have one. Any cursor code is going to be slow.
--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)

November 20, 2008 at 12:28 am

#900904
RE: Select based on Date- How to?

That's a pretty good and correct summary (heh... except for the format function). And, yes, you do understand.
--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)

November 19, 2008 at 10:19 pm

#900878
RE: MS SQL Aggregate Function

You bet. Thank you for the feedback.
Now you know why I asked to see your query. For more information on how to get better answers quicker on future...
--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)

November 19, 2008 at 10:16 pm

#900875
RE: getting rid of 0's in the start of a varchar(6) column

Phil Parkin (11/19/2008)
If it's numeric, cast to integer, otherwise leave as is:
declare @value varchar(10)
Set @Value = '0000006708'
if IsNumeric(@value) = 1
select cast(@value as integer)
else
select @value
Phil
Works fine......
--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)

November 19, 2008 at 9:36 pm

#900863
RE: MS SQL Aggregate Function

SELECT t.Title_ID, t.Type, t.Price, d.AvgPrice
FROM dbo.Titles t
INNER JOIN
(--==== Derived table "d" finds average Price for each...
--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)

November 19, 2008 at 9:32 pm

#900862
RE: Update Table based on Sum()

Thanks for the feedback...
Just a bit of undocumented warning... we've had several problems in the past where using a correlated subquery in the WHERE clause of an update will occasionally...
--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)

November 19, 2008 at 9:14 pm

#900858
RE: Optimizing Database Growth

Gaby A. (11/19/2008)
Thanks everybody, given me food for thought. Unfortunately this DB was set up before I joined my company but but at least in the future, if I...
--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)

November 19, 2008 at 9:02 pm

#900856
RE: Set Date Format on Flat File Source

Ted Zatopek (11/19/2008)
After lots of searching, I fanally ran across the term "fast parse" in an article and found the following MSDN article.
http://msdn.microsoft.com/en-us/library/ms139833(SQL.90).aspx
This seems to be just the trick I...
--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)

November 19, 2008 at 8:59 pm

#900855
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

Show me your code so I can modify it for 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)

November 19, 2008 at 8:46 pm

#900850
RE: Help with Money and Decimal datatype

Any feedback regarding my question, Karthick. Heh... "Inputs are welcome!" 😉
--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)

November 19, 2008 at 8:44 pm

#900849
RE: Using a SQL Stored Procedure to import an Excel spreadsheet

Sounds like a one time task... recommend you use SSIS to import the data into a "staging table" and then do an insert into the final table(s) from there.
--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)

November 19, 2008 at 8:42 pm

#900848
RE: field with multiple values

Alasdair Thomson (11/19/2008)
I hope this might be of use, we use the following function to breakdown the delimited list and then pass in our sp using cusors;
Please see the following......
--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)

November 19, 2008 at 8:33 pm

#900843

Viewing 15 posts - 47,101 through 47,115 (of 59,095 total)