Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,666 through 37,680 (of 59,098 total)

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
RE: The Private Cloud

I just left a "lecture" on "Azure". I have to say I'm a bit disappointed in some of the restrictions and lack of features (like a backup) even though...
--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:19 pm

#1193231
RE: SSIS - importing 1000 tables

mazzz (7/14/2010)
Thank you for your responses, Jeff and Todd.
Even using the wizard to create the initial package I would still have to go in and manually edit about 2000 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)

July 14, 2010 at 10:13 pm

#1193230
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/14/2010)
LutzM (7/14/2010)
OUCH!!!!
I immediately blacklist vendors with such a philosophy as soon as I'm getting aware of it...
I agree with you on that one.
What "philosophy" are you good...
--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 9:35 pm

#1193225
RE: Only customer accounts with + & - balances

smive2003 (7/14/2010)
Yes Jeff
I have up to 11 accounts per customer some with credit balances others in debit and need to limit my data to where they have 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)

July 14, 2010 at 2:12 pm

#1193110

Viewing 15 posts - 37,666 through 37,680 (of 59,098 total)