ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,071 through 8,085 (of 10,143 total)

RE: Today's Random Word!

John Rowan (3/30/2010)
You belong here in Nebraska with me Jason. One of the small towns outside of Omaha has a Testical Festival every year. It's a big attraction....
^{“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 31, 2010 at 2:10 am

#1142887
RE: Need help adding boolean count

Here's a little example of what you're looking to do:
DROP table #Fruits
create table #Fruits (FruitGroup CHAR(1), FruitName varchar(20), iLike BIT)
INSERT INTO #Fruits (FruitGroup, FruitName, iLike)
SELECT 'B', 'Strawberry', 1 UNION ALL
SELECT...
^{“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 30, 2010 at 10:27 am

#1142433
RE: Today's Random Word!

Crab
(Still hot, with fresh crusty French bread, salad, home-made pickled onions, and a bottle of cava = hog heaven)
^{“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 30, 2010 at 9:26 am

#1142353
RE: Today's Random Word!

gastropod
^{“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 30, 2010 at 7:04 am

#1142163
RE: Today's Random Word!

Fingerprint
^{“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 30, 2010 at 5:20 am

#1142070
RE: Today's Random Word!

Tuner
^{“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 30, 2010 at 4:52 am

#1142055
RE: Are the posted questions getting worse?

RBarryYoung (3/29/2010)
lmu92 (3/29/2010)
Just being curious: How close is that particular behavior of that specific person to be qualified as being a Troll? (disclaimer: limited to that particular thread due to...
^{“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 30, 2010 at 3:15 am

#1142029
RE: The Missing Certification

Just my 1p worth, and brief (still knackered from 6 weeks of non-stop need-it-yesterday development).
Each shop I've worked at has put a different set of criteria up front when hiring....
^{“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 29, 2010 at 7:23 am

#1141398
RE: Today's Random Word!

skedaddle
^{“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 22, 2010 at 9:28 am

#1137647
RE: Don't Look Ethel!

S Hodkinson (3/18/2010)
Just because I am paraniod does not mean that they are not after me. And yes, I have been doing this job for more years than I...
^{“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 18, 2010 at 7:47 am

#1135954
RE: Today's Random Word!

Paul White (3/16/2010)
mbricker-600840 (3/16/2010)
I used to work for a company that had a frozen marguerita machine in the kitchen
Why would anyone freeze a marguerita machine? 😛 :w00t:
It fooled the hippo?
^{“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 16, 2010 at 8:10 am

#1134453
RE: Are the posted questions getting worse?

RBarryYoung (3/14/2010)
Well, my back surgery is tomorrow (it got moved up). They've been putting me through medication withdrawal the last two weeks in preparation, so apologies if I've been...
^{“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 15, 2010 at 4:34 am

#1133580
RE: Where are you?

P Jones (3/11/2010)
Chris Morris-439714 (3/10/2010)
--------------------------------------------------------------------------------
Yes. In Swindon, computers change hands too quickly for any serious development to take place.
Sounds like Johannesburg. I'd probably feel right at home there.
No, Swindon's...
^{“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 11, 2010 at 9:54 am

#1132167
RE: Select top 2 based on dynamic criteria

nvrwrkn2 (3/11/2010)
Any idea on the code necessary to pull the top 2 distinct records, based on two date fields sorted datefield 1, datefield 2, for days of the week 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

March 11, 2010 at 6:13 am

#1131969
RE: Conditional 'NOT' in a WHERE clause

else x <> 1
But...you can't CASE a part of an expression:
WHERE x = CASE @var = 1 THEN 1 ELSE x END
AND x <> CASE WHEN @var <> 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

March 11, 2010 at 6:04 am

#1131966

Viewing 15 posts - 8,071 through 8,085 (of 10,143 total)