Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,836 through 23,850 (of 59,099 total)

RE: xp_create_subdir for non-sysadmins

jpoole (4/19/2014)
Hi,
Some details on the application - this system collects data from a 3D laser scanner that is imbedded in a robotic manufacturing cell. Meta data is stored in 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 19, 2014 at 2:29 pm

#1707289
RE: PIVOT May be the answer but help is needed with this conundrum.

As you point out, you have ten items in the table and you'll get 10 rows in the join for that one ContractID.
What's wrong with that? I'm...
--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 18, 2014 at 4:53 pm

#1707214
RE: BCP Output - Remove milliseconds part

SQListic (4/18/2014)
Hi All,
I The requirement is to unload all columns data into csv file using bcp with pipe delimitter, but the condition is to remove milliseconds part of a datetime...
--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 18, 2014 at 3:37 pm

#1707207
RE: PIVOT May be the answer but help is needed with this conundrum.

I guess my question would be to ask why you'd ever want to do this. It's a huge denormalization especially when you could have 100 columns. What would...
--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 18, 2014 at 3:34 pm

#1707205
RE: xp_create_subdir for non-sysadmins

Brandie Tarvin (4/17/2014)
There's got to be a better way for the users to get what they need, then.
There is. It's called "stored procedures".
And I'm curious as to the business...
--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 18, 2014 at 3:27 pm

#1707199
RE: Interview with the CTO ?!

clayman (4/17/2014)
Jeff Moden (4/12/2014)
clayman (4/12/2014)
So I was asked to answer a bunch of nasty Xpath syntax questions, needless to say I didn't get the job (not that 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)

April 17, 2014 at 10:13 pm

#1706969
RE: Select Only Rows with Alphabetical Character in Column

To make sure the you won't have a problem in the future with strings like 'SomeString1' or any other mix of characters including symbols especially in some of the collations...
--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 17, 2014 at 5:00 pm

#1706947
RE: Select Only Rows with Alphabetical Character in Column

ScottPletcher (4/17/2014)
Jeff Moden (4/17/2014)
ScottPletcher (4/17/2014)
WHERE column_name LIKE '[a-z]%'
That won't reject strings like '1.62073e+015'
It won't?? That string doesn't look like it starts with a letter to me...
--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 17, 2014 at 4:48 pm

#1706946
RE: Select Only Rows with Alphabetical Character in Column

ScottPletcher (4/17/2014)
WHERE column_name LIKE '[a-z]%'
That won't reject strings like '1.62073e+015'
--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 17, 2014 at 3:50 pm

#1706939
RE: xp_create_subdir for non-sysadmins

Brandie Tarvin (4/16/2014)
Jeff Moden (4/16/2014)
Brandie Tarvin (4/16/2014)
I answered the OP before I fully read your post. Searching your error on Google, I found this article from TechNet. Does it 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)

April 16, 2014 at 9:41 pm

#1706636
RE: First and Last Day Prior Month as Input Parameters

Welsh Corgi (4/16/2014)
I was thinking get the first day of the previous and current month to exclude the Timestamp and use a less then first day of current month?
I 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)

April 16, 2014 at 8:03 am

#1706475
RE: xp_create_subdir for non-sysadmins

Brandie Tarvin (4/16/2014)
rollercoaster43 (4/7/2014)
Hi Jeff,
Sorry to Jump in here but I was facing the same issue and thought of continuing on the thread.
I have a Stored procedure created in MAster...
--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 16, 2014 at 7:56 am

#1706467
RE: Consolidating Indexes

My first question would be... is the CX a UNIQUE index???
--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 16, 2014 at 7:52 am

#1706462
RE: recursive structure.

"Cycles" in hierarchies is always a problem for these types of things. It's usually because people (for example) can hold more than one position in an org chart (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)

April 16, 2014 at 7:50 am

#1706458
RE: Looking for elegant solution! Finding match over multiple rows

Sorry... post withdrawn. I really misread the question.
--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 16, 2014 at 7:47 am

#1706451

Viewing 15 posts - 23,836 through 23,850 (of 59,099 total)