ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,116 through 8,130 (of 10,143 total)

RE: TRICKY SQL QUERY

Hi Martin
Please don't take this the wrong way - we all have to learn somewhere. The query you posted is about as simple as it can get. Buy yourself this...
^{“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

March 3, 2010 at 8:14 am

#1127798
RE: Are the posted questions getting worse?

Hide the beer quick lads...HR's doing the rounds
^{“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

March 2, 2010 at 10:05 am

#1127241
RE: Are the posted questions getting worse?

Not really. It's this one which got me thinking about it, because the data looks very familiar and also because the OP doesn't appear to know what he/she's doing and...
^{“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

March 2, 2010 at 9:29 am

#1127200
RE: Are the posted questions getting worse?

"How about them Bears?" 🙂
Is it just me, or are the posters who appear to be the students, the ones who have the nerve to post their homework here, the...
^{“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

March 2, 2010 at 9:14 am

#1127171
RE: Are the posted questions getting worse?

Paul White (3/2/2010)
Chris Morris-439714 (3/2/2010)
You're welcome. This one's a cracker too. Do you mind if I pass it to a colleague here? And if that is ok with you, what...
^{“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

March 2, 2010 at 8:29 am

#1127136
RE: Are the posted questions getting worse?

Paul White (3/2/2010)
Sent. Thanks!
You're welcome. This one's a cracker too. Do you mind if I pass it to a colleague here? And if that is ok with you, what...
^{“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

March 2, 2010 at 7:37 am

#1127089
RE: Are the posted questions getting worse?

Paul White (3/2/2010)
Chris Morris-439714 (3/2/2010)
Not at 7.40am no, but I will be when the beer you promised turns up 😛
Ha! Has it been chilly in H€ll recently then?
On a...
^{“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

March 2, 2010 at 7:07 am

#1127056
RE: Are the posted questions getting worse?

Paul White (3/2/2010)
Chris Morris-439714 (3/2/2010)
Hey Paul, guilty as charged. It's going to be thursday evening before I can give the article the time it deserves. Reading it on the train...
^{“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

March 2, 2010 at 6:48 am

#1127029
RE: Are the posted questions getting worse?

Paul White (3/2/2010)
CirquedeSQLeil (3/1/2010)
Paul - good article.
Thanks Jason. I think it's pretty much ready for publication now, just waiting for the last couple of reviews to come in (hint...
^{“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

March 2, 2010 at 5:57 am

#1127003
RE: Get Similar recordes base on usage and matching criteria

Thank you Pritesh, this is very helpful.
The first part of your UNION query looks like this:
Select CandidateID as ID, '0' as Exp, Status
from @CandidateUsedForProject
where ProjectId in (Select a.ProjectId...
^{“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

March 2, 2010 at 2:20 am

#1126899
RE: Are the posted questions getting worse?

Alvin Ramard (3/1/2010)
So how's everyone today?
I'm not sure where my get-up-and-go is today. For some reason I feel emotionaly drained today.
What time do the pubs open where...
^{“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

March 1, 2010 at 8:18 am

#1126475
RE: Get Similar recordes base on usage and matching criteria

Hi Pritesh
It's not obvious what you are trying to do, but let's have a go anyway. The first thing to do is to break your problem down into separate parts,...
^{“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

March 1, 2010 at 7:12 am

#1126445
RE: how to replace uncounted multiple commas into one comma

RBarryYoung (4/4/2009)
Ramesh (4/4/2009)
Barry,
Well, I know it can easily extended to the next or higher level by adding another REPLACE of 9 commas or even 11 commas, but I just wanted...
^{“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

February 26, 2010 at 2:44 am

#1125443
RE: SQL 2005 Holding the last not value on several columns

Divya Agrawal (2/25/2010)
Good one Chris..
Thanks 🙂
^{“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

February 25, 2010 at 6:49 am

#1124929
RE: SQL 2005 Holding the last not value on several columns

Jacco
Assuming there are no gaps in your identity column:
;WITH Results AS (
SELECT pkId, Col1, Col2, Col3, Col4
FROM dbo.tblDemo
WHERE pkId = 1
UNION ALL
SELECT s.pkId,
ISNULL(s.Col1, r.Col1),
ISNULL(s.Col2, r.Col2),
ISNULL(s.Col3, r.Col3),...
^{“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

February 25, 2010 at 6:39 am

#1124920

Viewing 15 posts - 8,116 through 8,130 (of 10,143 total)