Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,216 through 34,230 (of 59,099 total)

RE: TSQL Logic help needed-- Nested IF

@Minnesota - Viking,
What do you want to do about dupes across the 4 columns?
--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 20, 2011 at 5:41 pm

#1314267
RE: TSQL Logic help needed-- Nested IF

Phil Parkin (4/20/2011)
Nice solution Jeff - except the priority is supposed to be 1,3,2,4 not 1,2,3,4 according to the orig post, so simple mod required.
--Edit, I was wrong. 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 20, 2011 at 4:26 pm

#1314255
RE: SQL DBA Needed in OH

Twin-soft.com SME (4/20/2011)
Dealertire is the company ...
How do you know which company it's 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 20, 2011 at 2:05 pm

#1314204
RE: Are the posted questions getting worse?

WayneS (4/20/2011)
Brandie Tarvin (4/20/2011)
WayneS (4/19/2011)
Greg Edwards-268690 (4/19/2011)
GSquared (4/19/2011)
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.
And Joe'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)

April 20, 2011 at 7:22 am

#1313922
RE: How replace

Lisset (4/18/2011)
Data to delete or change: JR ISMAEL ¹GADOR 298
Data to output: JR ISMAEL GADOR 298
User Function:
CREATE FUNCTION [dbo].[REMUEVE_SIMBOLOS_SE_FN](@str varchar(max))
RETURNS varchar(max)
AS
BEGIN
DECLARE @i int
DECLARE @r varchar(max)
...
--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 20, 2011 at 7:08 am

#1313909
RE: How replace

David Burrows (4/19/2011)
(don't want to steal his thunder :-D)
BWAA-HAA!!! Considering how badly I missed that the OP had posted the function I requested, there may be no thunder so...
--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 20, 2011 at 7:06 am

#1313908
RE: How replace

Phil Parkin (4/19/2011)
Jeff Moden (4/18/2011)
Lisset (4/18/2011)
Hi everybody, I has created a user function that replace any digit that don't been letter or number but when appear a number with superscript...
--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 20, 2011 at 7:01 am

#1313906
RE: hierarchyid traversing the tree.

You bet. Thank you for the feedback.
--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 20, 2011 at 6:51 am

#1313899
RE: Script to generate a SQL table from a table structure (from the field names)

GaMusicMan (4/19/2011)
I found the solution below. I do appreciate you taking the timne to read my post.
Here is the solution if anyone else has a similar project.
Use DHL_KEMP_Load...
--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, 2011 at 7:28 pm

#1313709
RE: TSQL Logic help needed-- Nested IF

Minnesota - Viking (4/19/2011)
I appolozize for the unethical post.
I am atatching three scripts:
1. TO create the table
2. TO insert sampel Data
3. Expected results for about 13 records out...
--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, 2011 at 6:36 pm

#1313703
RE: How replace

Lisset (4/18/2011)
Hi everybody, I has created a user function that replace any digit that don't been letter or number but when appear a number with superscript or subscript(ej: ¹) recognize...
--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, 2011 at 7:01 pm

#1313154
RE: Which index run first Clustered index or Non_Clustered index

Heh... great interview questions and scenario. 😀
--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, 2011 at 6:46 pm

#1313152
RE: Creating loops within loops

kmaker (4/18/2011)
Wayne,
Thank you very much for the info on how to post.
Unfortunately I cannot get the table definitions of the SCADA (supervisory control and data acquisition) data so 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 18, 2011 at 6:30 pm

#1313149
RE: Performance on very large database - Help

p.s. According to what you posted... since you don't have a clustered on that table and I saw a FILL FACTOR of 100 running around in that code, you...
--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, 2011 at 6:20 pm

#1313146
RE: Performance on very large database - Help

aGuareschi (4/18/2011)
select * from vipt_tab_003
where pt03_annomese = 201001
and pt03_r_abi = 'XXXXX'
and pt03_num_eff = '569845456165748'
I agree with Syed above. The index you created doesn't have all the columns of your...
--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, 2011 at 6:10 pm

#1313144

Viewing 15 posts - 34,216 through 34,230 (of 59,099 total)