Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,326 through 38,340 (of 59,098 total)

RE: Verifying Data against a list of symbol characters

lmu92 (5/18/2010)
Would something like the following help?
SELECT * FROM
(
SELECT 'Smith John' AS lastname UNION ALL
SELECT 'S#ith Jane' UNION ALL
SELECT '\ Jim' UNION ALL
SELECT 'Anderson Ken' UNION ALL
SELECT 'Smith-Barny Andre'''
) a
WHERE...
--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 18, 2010 at 4:45 pm

#1169160
RE: How do I count the occurrences of a sequence of records

Heh... great minds think alike, Lutz... your post wasn't there when I started typing my post. 😛
--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 18, 2010 at 4:35 pm

#1169155
RE: How do I count the occurrences of a sequence of records

Hmmmm... I'm thinking you could get a false count if the data looked like...
Re-Open
whatever
whatever
Re-Open
whatever
whatever
Ready For Build
I don't know if that could ever happen but I see nothing to prevent such...
--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 18, 2010 at 4:35 pm

#1169154
RE: Best SQL Server Edition for a offline application

MTY-1082557 (5/18/2010)
Thank you all,
My end user is not our developers, are the users that manage the application. I'm thinking about the Express Edition. I never heard about the compact...
--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 18, 2010 at 4:21 pm

#1169146
RE: SQL to manipulate rows of data

I actually did mean "Nice Try" as in "good job" and "almost right". It was meant to be a compliment because I've seen many posts that don't...
--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 18, 2010 at 4:14 pm

#1169142
RE: Help with Date part

Rob Schripsema (5/18/2010)
I do not think ISDATE() is a good way to solve the problem OP has. Also, given the anomalies, I was wondering when would you use ISDATE() 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 18, 2010 at 3:58 pm

#1169135
RE: Help with Date part

rjv_rnjn (5/18/2010)
Rob Schripsema (5/18/2010)
BUT --- the OP gave an example where the so-called date was in a nn/nn/nnnn format, and the problem was just that one (or potentially more) 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)

May 18, 2010 at 3:15 pm

#1169131
RE: Help with Date part

sql.kishore1 (5/18/2010)
Rob Schripsemasolution Solves my ISSUE.
Rob's code is technically correct for what it was intended to do but you need to make real sure that you don't have entries...
--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 18, 2010 at 3:10 pm

#1169129
RE: Comparing two rows in one table for changes in column

Dobermann (5/18/2010)
I kinda figured that out afterwards but thanks for the feedback.
On the Dose/Frequency thing... it shouldn't make a difference. If the code works on one it should work...
--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 18, 2010 at 3:06 pm

#1169127
RE: Comparing two rows in one table for changes in column

Heh... maybe it is I who is going brain dead concerning changes in requirements but ...
Dobermann (5/17/2010)
I am beginning to think that perhaps rather than having one query for changes...
--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 18, 2010 at 7:39 am

#1168814
RE: Tally Table to split string

Very cool. Thanks for the time to make a feedback. If you get the chance, post your code so folks can see what you've done with PIVOT.
--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 18, 2010 at 7:23 am

#1168801
RE: Remove Pattern in sql query

niteshrajgopal (5/18/2010)
Hi again, is there anyway I can add to your reputation or something on this forum:-)
Heh... not to worry. CC is building his reputation where it counts. 😉
--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 18, 2010 at 5:38 am

#1168723
RE: Working With comma Separated values

:Whistling:
--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 17, 2010 at 9:49 pm

#1168573
RE: How to Convert Rows into Columns?

Sahasam (5/17/2010)
You are right jeff, But I had very few number of records(Around 3000). so i am using the functions.
Sahasam...
Heh... you've hit a bit of a sore spot with me...
--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 17, 2010 at 9:16 pm

#1168570
RE: Database Size Increase After Index Rebuild

I'm not so sure there's a penalty if you use just the "Release Unused Space" in the "File" shrink. I don't believe there's any reorganization when that particular option...
--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 17, 2010 at 9:12 pm

#1168567

Viewing 15 posts - 38,326 through 38,340 (of 59,098 total)