ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,171 through 7,185 (of 10,143 total)

RE: Are the posted questions getting worse?

WayneS (10/18/2010)
Steve Jones - SSC Editor (10/18/2010)
I'm with Lynn. I'm not sold that global warming, even if it is happening, is a bad thing. It might be part of 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

October 19, 2010 at 2:30 am

#1238883
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/18/2010)
I'm with Lynn. I'm not sold that global warming, even if it is happening, is a bad thing. It might be part of a long...
^{“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

October 19, 2010 at 2:26 am

#1238881
RE: Are the posted questions getting worse?

GSquared (10/18/2010)
Steve Jones - SSC Editor (10/18/2010)
Alvin Ramard (10/18/2010)
Jeff Moden (10/17/2010)
Steve Jones - SSC Editor (10/14/2010)
The green value, if there is one, comes not from you getting ebooks, but from...
^{“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

October 19, 2010 at 2:22 am

#1238877
RE: Are the posted questions getting worse?

Paul White NZ (10/18/2010)
Steve Jones - SSC Editor (10/18/2010)
Jason (10/18/2010)I think most trees are brown on the outside with a topcoat (needles or leaves) that may or may not be...
^{“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

October 19, 2010 at 2:11 am

#1238874
RE: Are the posted questions getting worse?

nigel. (10/18/2010)
UPDATE
MyHomework
SET
Answer = 'Correct'
WHERE
MyEffort IS...
^{“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

October 18, 2010 at 8:25 am

#1238441
RE: Today's Random Word!

Muffin top.
^{“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

October 18, 2010 at 7:32 am

#1238395
RE: Are the posted questions getting worse?

Brandie Tarvin (10/18/2010)
WayneS (10/16/2010)
I just love these!
"I've got this task, needs to be done in an insert trigger".
So, I give the code for doing so.
"Now, can you incorporated it...
^{“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

October 18, 2010 at 4:56 am

#1238311
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/15/2010)
...He - I got run off the road last night by a woman driving an SUV...
That's the school run for you.
^{“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

October 18, 2010 at 2:11 am

#1238261
RE: Index not getting used when where clause uses variable, index is getting used when value is hard coded.

Using a function on the lower bound of the date range is also likely to cause problems. Try this instead:
DECLARE @workh_date_out DATE
SET @workh_date_out = DATEADD(month, @Month * -1, @TodaysDate)
WHERE (
(workh_date_out...
^{“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

October 15, 2010 at 6:56 am

#1237483
RE: Recursive Query

Post what you've tried already.
Can you set up some sample data? One of the links in my sig will show you how to do 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

October 15, 2010 at 6:24 am

#1237462
RE: Are the posted questions getting worse?

Alvin Ramard (10/14/2010)
Good idea Jason. Where can I find a wife before Xmas? 😀
http://www.CompareTheHamster.com
^{“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

October 15, 2010 at 2:13 am

#1237345
RE: Msg 102, Level 15, State 1, Line 1

a475668 (10/14/2010)
Hi Can anyone help me.
I get this erro:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
when i execute the below code.
ALTER procedure [spOutputFinalFile] as
set nocount on
Declare...
^{“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

October 14, 2010 at 10:18 am

#1237011
RE: Today's Random Word!

crookj (10/14/2010)
Brandie Tarvin (10/14/2010)
crookj (10/14/2010)
Kit G (10/14/2010)
Vampira
Early 70's - Bringing back some GOOD memories. If I was ever bit by a Vampire - She would be the one I would...
^{“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

October 14, 2010 at 9:02 am

#1236913
RE: Today's Random Word!

Carmen gettit
^{“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

October 14, 2010 at 8:05 am

#1236868
RE: Today's Random Word!

Carmen Electra
^{“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

October 14, 2010 at 7:36 am

#1236842

Viewing 15 posts - 7,171 through 7,185 (of 10,143 total)