Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,911 through 38,925 (of 59,102 total)

RE: which software?

If you're looking for a "perfect" copy of production to put into development and have a decent SAN, then you could use a "SAN Snapshot" (has nothing to do with...
--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 15, 2010 at 7:04 pm

#1152551
RE: Test - ignore this

You CAN post code... look at the "IFCode Shortcuts" when you create a new post or reply to one. Surround your code with one of the shortcut "pairs" 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 15, 2010 at 7:08 am

#1152076
RE: Select a string when data in the string varies

WayneS (4/14/2010)
Jeff Moden (4/14/2010)
Wayne... just split on the "=" sign using SUBSTRING and CHARINDEX. It doesn't need to be Pivoted using a CrossTab to be used very effectively.
I utilized...
--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 15, 2010 at 6:25 am

#1152049
RE: Continuing Education

skjoldtc (4/14/2010)
I think some standards should exist. I don't necessarily want government involved, but, at some level to help identify what a person can do at a basic level.
I've known...
--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 14, 2010 at 3:07 pm

#1151767
RE: Select a string when data in the string varies

WayneS (4/14/2010)
bill.brazell (4/14/2010)
This is looking very promising. Thank you.
As for the output, I'd prefer that it not include the name of the delimiter, only the value. i.e. "Ping"...
--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 14, 2010 at 2:59 pm

#1151760
RE: Select a string when data in the string varies

Heh... actually, I've added more comments in the form of a usage example and some extra credits... My intent is to do a long overdue update on the Tally...
--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 14, 2010 at 5:45 am

#1151246
RE: Continuing Education

John.Sansom (4/14/2010)
You mention that I.T does not have regulation to the extent of other professionalisms but there are organisations that are endeavouring to achieve this.
In the United Kingdom there is...
--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 14, 2010 at 5:28 am

#1151236
RE: Continuing Education

abrar.ahmad-1058946 (4/13/2010)
[font="Verdana"]Can anyone of ranks higher than "Old Hand"(SSC ranking) let forward some exceptional tips for "SSC Rookie" or less to attain/pave their career with a Plus? :smooooth:
------------------- :exclamationmark:[/font]
or they...
--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 14, 2010 at 5:19 am

#1151231
RE: Insert Rows from a Parsed Field into Another Table

{edit} Machine dependent code removed. Sorry folks.
I ran into a bit of a buzz saw with the new split function that I previously posted (and have removed from this...
--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 13, 2010 at 9:53 pm

#1151122
RE: Select a string when data in the string varies

{edit} Machine dependent code removed... sorry folks.
--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 13, 2010 at 9:44 pm

#1151119
RE: Select a string when data in the string varies

Heh... ya did it to me again, Wayne. 😉
--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 13, 2010 at 8:54 pm

#1151111
RE: not allow the user to copy the report

I don't know the answer to your question but I have to ask... why do you want to do this? :blink:
--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 13, 2010 at 8:28 pm

#1151105
RE: change datatype of a column having clustered index

rpatil22 (4/13/2010)
I want to change datatype of a column having clustered index.
ALTER TABLE ProdMachine
ALTER COLUMN MachineID Varchar(10) NOT NULL
error -
Msg 5074, Level 16, State 1, Line 1
The index 'IX_Clust_ID' is...
--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 13, 2010 at 6:28 pm

#1151090
RE: Dates on the Where Statement

homebrew01 (4/13/2010)
Also, keep in mind that if you don't include the hours & minutes, SQL assumes 00:00:00. That can be important sometimes. If you were searching for <= instead...
--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 13, 2010 at 6:17 pm

#1151086
RE: Data verification question

cjohn5552 (4/12/2010)
One more question on the topic. I've been trying to do some reading up on regular expressions, but most of the resources I get seem to be concerned with...
--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 13, 2010 at 5:32 pm

#1151073

Viewing 15 posts - 38,911 through 38,925 (of 59,102 total)