Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,121 through 30,135 (of 59,101 total)

RE: Finding rows with wildcards in the string and rows with spaces in front or at the end of the string.

You're welcome. Take a look at one of the many uses for it in the following article...
http://www.sqlservercentral.com/articles/IsNumeric/71512/
--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)

May 10, 2012 at 12:34 am

#1485481
RE: String conversion

dwain.c (5/9/2012)
Even though I think you're showing off, I have to ask.
Can I use this? :w00t:
Sure thing. The only price you have to pay is to tell me 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)

May 10, 2012 at 12:16 am

#1485477
RE: Capture Changed records

kshah82 (5/8/2012)
Hi,
Kalpa? Washington State?
--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)

May 9, 2012 at 11:53 pm

#1485470
RE: String conversion

BWAAA-HAAA!!! This will do it! :-P:-D Makes a "great" interview question. :sick:
WITH F(x) AS (SELECT TOP (CHECKSUM(66-ASCII('A'))) '/'+CONVERT(CHAR(8),GETDATE(),CAST(EXP(0) AS INT)) FROM sys.objects)
SELECT STUFF(REPLACE(LEFT(x,POWER(73,1/2)*POWER(25,1/2.0)),'/0','/')
...
--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)

May 9, 2012 at 11:29 pm

#1485461
RE: query works but not in a view

PaulB-TheOneAndOnly (5/9/2012)
If MSTR_END on WHERE clause is causing the issue replace the condition with:
where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''
IIRC, that'll make for a non-SARGable search predicate just like in T-SQL. 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)

May 9, 2012 at 9:52 pm

#1485441
RE: US Date Format in SQL Server

I'll strongly second that. Storing formatted dates and times in SQL might look good from where you're standing right now but you'll pay dearly for it in the future....
--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)

May 9, 2012 at 9:37 pm

#1485434
RE: Are the posted questions getting worse?

Lynn Pettis (5/9/2012)
Sorry for the code, but I need a place to keep these solutions for a hypothetical problem on another thread.
Wow! Working with Oracle really did put 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)

May 9, 2012 at 8:30 pm

#1485426
RE: RegEx for DBAs

SAinCA (5/9/2012)
Jeff Moden (5/9/2012)
sherifffruitfly (5/8/2012)
As for the pissing match - meh. There's times to use stuff and times not to. Never been a fan of the religious fanatics on either...
--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)

May 9, 2012 at 8:21 pm

#1485424
RE: RegEx for DBAs

Solomon Rutzky (5/9/2012)
And again, I don't think David is trying to convince anyone that they simply must use Regular Expressions. It is a matter of exposing people to a powerful...
--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)

May 9, 2012 at 8:08 pm

#1485423
RE: RegEx for DBAs

sherifffruitfly (5/8/2012)
As for the pissing match - meh. There's times to use stuff and times not to. Never been a fan of the religious fanatics on either the ALWAYSUSEIT and...
--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)

May 9, 2012 at 7:28 pm

#1485415
RE: RegEx for DBAs

corey lawson (5/9/2012)
We should all try not to be too dogmatic about things. Even CURSORs and cross-joins have their uses, after all (and not everything tastes better with tabasco sauce...
--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)

May 9, 2012 at 7:05 pm

#1485409
RE: Finding rows with wildcards in the string and rows with spaces in front or at the end of the string.

cadm777 (5/9/2012)
Jeff,
That worked great! Thanks.
Here is my final query:
Select SEAL, * FROM toolsDB.CONTENT
Where Seal LIKE '%[^ 0-9A-Z]%'
OR DATALENGTH(LTRIM(RTRIM(Seal)))<>DATALENGTH(Seal)
Looks like I need...
--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)

May 9, 2012 at 6:51 pm

#1485408
RE: Finding rows with wildcards in the string and rows with spaces in front or at the end of the string.

vinu512 (5/9/2012)
Jeff Moden (5/8/2012)
Do you really mean that all you want to see is things that have other than 0-9 or A-Z or embedded spaces in them?
If so, you can...
--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)

May 9, 2012 at 6:49 pm

#1485407
RE: RegEx for DBAs

borisk 57245 (5/9/2012)
Ok, NP.., Kinda new in SQL forums
NP. Thanks for the post and it turns out to be pretty much as I suspected. You use an...
--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)

May 9, 2012 at 6:07 am

#1484996
RE: Output to CSV or txt file from Query Window

Phil Parkin (5/8/2012)
If you write the results of your query out to a table which is created on the fly (find a way of naming the table uniquely), you can...
--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)

May 8, 2012 at 7:10 pm

#1484833

Viewing 15 posts - 30,121 through 30,135 (of 59,101 total)