ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,876 through 7,890 (of 10,143 total)

RE: How to indicate rows with identical values in certain column

bnordberg (5/21/2010)
I do similiar stuff all the time - I look at prescription drug history and lab values and look for changes that would indicate adverse drug events, drug seeking...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 8:43 am

#1170883
RE: Today's Random Word!

John Rowan (5/21/2010)
Chris Morris-439714 (5/21/2010)
John Rowan (5/20/2010)
I have 5 kids under the age of 10
I reckon we should all club together and buy John a telly.
Telly?
Something else to do...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 8:28 am

#1170870
RE: How to indicate rows with identical values in certain column

marin-231997 (5/21/2010)
Hello bnordberg,
well, I'd really like to see how your queries look like after you've had your cup of coffee 🙂 , but this one just hits the nail on...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 8:26 am

#1170869
RE: Tricky Aggregation

cgreathouse (5/21/2010)
I've tried something similar without much luck. Thanks for trying!
I'm now playing around with CTEs to see if that will work. Anybody else have any suggestions?
Thanks!
Yep, if...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 8:12 am

#1170854
RE: How to indicate rows with identical values in certain column

marin-231997 (5/21/2010)
Hello Chris,
thanks for your input.
Unfortunately it is not what I'd like to achieve. I need a way to "flag" the rows having identical values in column _VAL3 (kind of...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 8:04 am

#1170846
RE: How to indicate rows with identical values in certain column

marin-231997 (5/21/2010)
Hello all,
I wonder if following is somehow possible:
I'd like to add an extra column to my existing query which would indicate the rows with identical values in certain column.
Sample...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 7:53 am

#1170832
RE: How to default Zero-length string to NULL ?

Have you looked into Jeff's suggestion yet?
NULLIF(MyDodgyColumn, '')
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 7:45 am

#1170824
RE: Interesting problem for the "Running Total/Quirky Update" method of removing cursors

Robb, can you please confirm that you are running on SQL Server 7 or 2k?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 7:43 am

#1170821
RE: using CASE in a WHERE clause

And if it is correct, then this should do the trick:
SELECT
p.packageID,
p.ClientID,
p.StartDate,
p.EndDate,
DATEPART(MONTH, GETDATE()) AS currMonth
FROM p
WHERE
(p.StartDate <= CONVERT(datetime, CONVERT(varchar,DATEPART(year,GETDATE()) +
CASE WHEN DATEPART(MONTH, GETDATE()) >...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 7:24 am

#1170802
RE: using CASE in a WHERE clause

Oh don't worry about that, getting the conditional to work properly is the easy bit. Getting the logic engraved in stone first is essential - and the hard bit. Now,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 7:19 am

#1170800
RE: Egg exists in the basket ???

karthikeyan-444867 (5/20/2010)
Step1 : User will pass delimited values.
Step2 : I used 'Tally' table to split the delimited values
Step3 : Splittled values will be stored in a table as rows.
...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 4:31 am

#1170697
RE: Getting the dates between a range

What have you tried so far?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 4:01 am

#1170684
RE: using CASE in a WHERE clause

Hi David
Could you please review the attached pseudocode and confirm that it's logically what you're looking for?
DECLARE @NextMarch DATETIME, @ThisMarch DATETIME, @ThisApril DATETIME, @LastApril DATETIME
SET @NextMarch = convert(datetime, convert(varchar,datepart(year,getdate())+1) +...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 3:13 am

#1170666
RE: Today's Random Word!

John Rowan (5/20/2010)
I have 5 kids under the age of 10
I reckon we should all club together and buy John a telly.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2010 at 2:09 am

#1170642
RE: Today's Random Word!

CirquedeSQLeil (5/20/2010)
Paul White NZ (5/20/2010)
Chris Morris-439714 (5/20/2010)
Paul White NZ (5/20/2010)
Chris Morris-439714 (5/20/2010)
Paul White NZ (5/20/2010)
Dynamic SQL - versus - not very dynamic DBAs.
Hey Chris, what's with the paint tin avatar?
Paint...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 20, 2010 at 10:18 am

#1170296

Viewing 15 posts - 7,876 through 7,890 (of 10,143 total)