Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,636 through 37,650 (of 59,072 total)

RE: Help with using mulitple replace in a function

Julie Breutzmann (7/15/2010)
I work in higher ed and our budget has been cut significantly. To make matters worse a significant portion of our budget is non-discretionary. 🙁
Damn... I'll never 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)

July 15, 2010 at 2:05 pm

#1193767
RE: Help with Query

Eralper (7/15/2010)
Hello dheer,
Please thy the following select query
select
name,
MAX(dob), MAX(maths), MAX(science), MAX(chemisty), MAX(physics),
MAX(maths) + MAX(science) + MAX(chemisty) + MAX(physics)
from lessons
group by name
I hope that helps you
The problem with that...
--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)

July 15, 2010 at 1:59 pm

#1193761
RE: Getting Data back from a Stored Proc

Paul White NZ (7/15/2010)
Gianluca Sartori (7/15/2010)
...but consider that this solution can lead to very extensive row locks if run inside transactions...
Yes that's one of the things to watch out for,...
--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)

July 15, 2010 at 1:56 pm

#1193759
RE: Function in Joining column degrades performance in 2008

TheSQLGuru (7/15/2010)
I might have missed it, but did anyone mention that when upgrading from SQL 2000 to SQL 2008 you MUST update ALL statistics with a FULL SCAN?
Also did we...
--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)

July 15, 2010 at 1:51 pm

#1193756
RE: Exportar datos a dbf

Thanks, Paul.
--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)

July 15, 2010 at 1:49 pm

#1193755
RE: Between Statment only for current day

jon pill (7/15/2010)
Really sorry about this,
But I can only run the query once
Msg 2714, Level 16, State 6, Line 1
There is already an object named '#TodayRecords' in the database.
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)

July 15, 2010 at 1:38 pm

#1193749
RE: Are the posted questions getting worse?

Tom.Thomson (7/15/2010)
Paul White NZ (7/14/2010)
Jeff Moden (7/14/2010)
What "philosophy" are you good folks referring to?
Presumably something around people who won't take the time to 'fix' a problem 'properly'.
As it happens, 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)

July 15, 2010 at 1:25 pm

#1193744
RE: Help with using mulitple replace in a function

Julie Breutzmann (7/14/2010)
That looks promising, Lowell. I'd need to add a piece for special letters like those with accents, umlauts, etc. I've used tally tables before, thanks to Jeff Moden's...
--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)

July 15, 2010 at 12:30 am

#1193261
RE: Help with using mulitple replace in a function

Eugene Elutin (7/14/2010)
Julie Breutzmann (7/14/2010)
...
What would be an efficient way to code this?
...
If you need high-performance heavy string manipulation functions write them as CLR functions in c#. T-SQL UDF 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)

July 15, 2010 at 12:04 am

#1193255
RE: Help with Query

Also, since you're new, please study the article at the first link in my signature line below. People will trip over each other to help you if you 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)

July 14, 2010 at 11:58 pm

#1193252
RE: Exportar datos a dbf

Would anyone care to do a translation for the rest of us, please? Thanks.
--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)

July 14, 2010 at 11:54 pm

#1193250
RE: Very Tough CSV Data Import to SQL 2005 DB Table Challenge

dsabjp (7/14/2010)
I am going to attach an Excel workbook with three worksheets. The worksheets contain:
1. A picture of the product and measurements that will be provided in a CSV...
--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)

July 14, 2010 at 11:36 pm

#1193247
RE: Are the posted questions getting worse?

I'm on vacation in RI to see my parents. It just so happened that my vacation coincided with the local PASS user group meeting. The meeting was 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)

July 14, 2010 at 10:56 pm

#1193237
RE: Are the posted questions getting worse?

Paul White NZ (7/14/2010)
Jeff Moden (7/14/2010)
What "philosophy" are you good folks referring to?
Presumably something around people who won't take the time to 'fix' a problem 'properly'.
As it happens, I think...
--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)

July 14, 2010 at 10:49 pm

#1193236
RE: Getting Data back from a Stored Proc

Paul White NZ (7/14/2010)
This seems like a perfectly reasonable attempt to implement a Sequence Table to me.
The code can be simplified:
-- Sequence table, holds next PK per table
CREATE TABLE...
--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)

July 14, 2010 at 10:46 pm

#1193234

Viewing 15 posts - 37,636 through 37,650 (of 59,072 total)