Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,296 through 38,310 (of 59,072 total)

RE: Remove Pattern in sql query

{edit} Sorry... had a bug in the code and had to remove this post.
{edit} {edit} Heh... it turned out to not be a bug. The Tally table code...
--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 8:48 pm

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

Here you go... I guarantee that it only finds changes, now...
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#RX','U') IS NOT NULL
...
--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:13 pm

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

Ah... I see why you say too many rows showed up. We need to define what actually needs to happen when the Frequency changes. The current definition 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)

May 18, 2010 at 6:50 pm

#1169184
RE: T-SQL Query Performance question!

Just curious... how many rows do the tables actually have in them? The fact that DISTINCT is being used to overcome some obviously duplicated output leads me to believe...
--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:53 pm

#1169163
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

Viewing 15 posts - 38,296 through 38,310 (of 59,072 total)