ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,701 through 8,715 (of 10,143 total)

RE: Are the posted questions getting worse?

Bruce W Cassidy (3/10/2009)
Lynn Pettis (3/10/2009)
Effort worth expending not.
[font="Verdana"]Forth like honk if.[/font]
Well oil beef hooked!
^{“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, 2009 at 3:19 am

#957330
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

Wayne (3/9/2009)
Jeff is right. I have to cater for non-trading days other than weekends (which are not included in my sample data) so having a 7 day difference 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

March 10, 2009 at 1:43 pm

#957048
RE: Are the posted questions getting worse?

Roy Ernest (3/10/2009)
Here is someone who is almost ready to drive people nuts...
Well worth reading for Brandie's definition of RBAR 😀
^{“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 10, 2009 at 8:20 am

#956813
RE: SQL Query not running...

Dugi (3/9/2009)
This should work let us know:
SELECT * FROM TBLDEALS
WHERE CONVERT(VARCHAR(20),trade_date, 120) = '2009-03-06 00:00:00'
It might work, Dugi, but it's not going to be quick! Far better to convert one...
^{“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 9, 2009 at 8:58 am

#956080
RE: Are the posted questions getting worse?

GSquared (3/9/2009)
RBarryYoung (3/7/2009)
As Woody Allen once said:
"I'm not sure I want to join any club that would have me as a member."
Either he stole that one from Groucho Marx,...
^{“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 9, 2009 at 7:20 am

#955955
RE: SQL Query not running...

A Little Help Please (3/9/2009)
where trade_date = '2009-03-06 00:00:00'
Assuming trade_date is a datetime column, what do you think the result of the implicit conversion of the string '2009-03-06 00:00:00' 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 9, 2009 at 7:04 am

#955940
RE: how to read unique records based a field that have duplicate values

DURGESH (3/9/2009)
hi
if my table is as follows
col1 col2 col3
aa ram b
bb ram a
cc ravi ...
^{“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 9, 2009 at 6:46 am

#955922
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

Jeff Moden (3/7/2009)
Actually, in SQL Server 2k5, we don't need to solve the running total problem for this because it's just a ranking problem... this should do it...
;WITH
cteGroup...
^{“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 9, 2009 at 3:41 am

#955847
RE: Are the posted questions getting worse?

GilaMonster (3/8/2009)
Jeff Moden (3/7/2009)
Consider the OP in the following... Lynn may have competition for saint-hood... 🙂
http://www.sqlservercentral.com/Forums/Topic670491-338-1.aspx
Mike is one of those people on my blacklist, due to his repeated demonstrations that...
^{“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 8, 2009 at 9:33 am

#955673
RE: "Answered" Posts

Steve Jones - Editor (3/6/2009)
I don't see how comments are rated in the New Scientist thing. I missing something?
Not really, Steve. It's simply an example of where ranking works well,...
^{“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 7, 2009 at 2:00 am

#955425
RE: Are the posted questions getting worse?

Grant Fritchey (3/6/2009)
Remember, don't feed the trolls.
'Nuff said.
^{“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 6, 2009 at 1:49 pm

#955252
RE: "Answered" Posts

jcrawf02 (3/6/2009)
Chris Morris (3/6/2009)
In any case, the best or, more rarely, the correct answer here is usually blindingly obvious.
To you, Chris, or to someone who knows that they're doing. ...
^{“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 6, 2009 at 10:08 am

#955066
RE: "Answered" Posts

Here's a great example of how "mark as correct" or "mark as answered" really works. All of the answers are preserved, one or more are flagged up.
So what is 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 6, 2009 at 9:50 am

#955047
RE: Are the posted questions getting worse?

Ninja's_RGR'us (3/6/2009)
Nope only another 19 needed, 18 after you reply to this! 😉
Ooh will there be a party? Can I bring beer? 😀
^{“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 6, 2009 at 9:13 am

#954991
RE: Error in Stored Procedure with view :SSRS

Interesting - if you're dropping and recreating the view in this sproc, then everything else which references the view must do the same - otherwise, the view definition is unknown...
^{“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 6, 2009 at 5:53 am

#954791

Viewing 15 posts - 8,701 through 8,715 (of 10,143 total)