Jeff Moden

Forum Replies Created

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

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
RE: Understanding and Using APPLY (Part 1)

korolana (4/13/2010)
Nice article, but what is an advantage to use this approach vs simple join?
From the performance point of view I don't think that calling UDTF on every row 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 13, 2010 at 1:59 pm

#1151003
RE: Recursive queries - get the top N quantity

steve-lauzon (4/13/2010)
Holy smokes !
Thanks a lot guys... you've just saved me a bunch of time - just the solution I was searching for
Can't wait for the day that I'll be...
--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 7:34 am

#1150712
RE: Recursive queries - get the top N quantity

P.S. I don't believe that FLOAT is the thing to use here. Could be wrong, 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)

April 12, 2010 at 11:01 pm

#1150484
RE: Recursive queries - get the top N quantity

This could probably stand a tweek here and there but here's the code I came up with that I was going to post before you beat me to the punch....
--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 12, 2010 at 11:00 pm

#1150483

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