Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,871 through 48,885 (of 59,093 total)

RE: Find distinct special characters in column

ps. If your yourdistinctlistofcharacters is supposed to contain a single quote, you'll need to include it twice. If yourdistinctlistofcharacters is supposed to contain brackets, then you'll need to...
--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)

August 10, 2008 at 9:07 am

#855756
RE: Find distinct special characters in column

shamshad.ali (8/9/2008)
The problem is I have to "Find DISTINCT SPECIAL characters in column [NTLogin]"
Shamshad Ali.
With a minor modification, Peso's solution will do it...
SELECT * FROM Users
WHERE UserName LIKE '%[yourdistinctlistofcharacters]%'
Change 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)

August 10, 2008 at 9:05 am

#855754
RE: SQL Brain

CREATE TABLE #MyHead....
--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)

August 9, 2008 at 7:15 pm

#855720
RE: hello our Experts where are you????????????

Heh... that's the most blatant "bump" I've ever seen. 😛
Seem like you have a couple of good answers there. I'd continue your post there if I were 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)

August 9, 2008 at 7:05 pm

#855718
RE: Beginner Question about CLR

GilaMonster (8/9/2008)
Jeff, do you know if anyone's tested the speed of a CLR proc vs the built in XQuery for shredding xml documents?
No, I sure don't, Gail. Sorry.
--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)

August 9, 2008 at 5:21 pm

#855716
RE: @@IDENTITYin very busy site - if many insert in same time What happend?

Peter, are you, by any chance, going to PASS this year? Sure would like to me you in person, someday.
--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)

August 9, 2008 at 5:19 pm

#855715
RE: Beginner Question about CLR

Just a bit of advice to a beginner... Most of the time where someone thinks they need a CLR, Matt and I have been able to beat the pants off...
--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)

August 9, 2008 at 11:26 am

#855700
RE: Recursive Queries in SQL:1999 and SQL Server 2005

Thanks Paul.
--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)

August 9, 2008 at 10:54 am

#855697
RE: @@IDENTITYin very busy site - if many insert in same time What happend?

Heh... even SCOPE_IDENTITY() doesn't fix that problem. 🙂
--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)

August 9, 2008 at 10:48 am

#855695
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Hugo Kornelis (8/7/2008)
As Jeff already said, this might not be the best way to find your first gap. Here are two alternatives that...
Here's another take on the same problem... test...
--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)

August 9, 2008 at 10:42 am

#855694
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Thanks for the feedback, Atif!
--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)

August 9, 2008 at 10:36 am

#855693
RE: Creating a running difference - sort of

Awesome. Thanks for the feedback, Buzz.
--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)

August 9, 2008 at 10:34 am

#855692
RE: Concatentate Column For Duplicate Key record

Dang... Yeaup... I already knew about the prettifier... was hoping there was something a bit more auto-magic... 🙂
--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)

August 8, 2008 at 10:18 pm

#855615
RE: Concatentate Column For Duplicate Key record

Ok... fair trade... I give you a solution... you tell me what you're using to format you code for the code entries on this forum... (please :))
--=====================================================================================================================
-- ...
--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)

August 8, 2008 at 9:14 pm

#855610
RE: BCP Remote Files

You are correct... BCP can write anywhere that the server can "see". The SQL Server SERVICE must have a Windows Server login that can "see" the UNC path that...
--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)

August 8, 2008 at 7:08 pm

#855600

Viewing 15 posts - 48,871 through 48,885 (of 59,093 total)