ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,126 through 7,140 (of 10,143 total)

RE: Calculating interest query

Paul White NZ (10/29/2010)
...in the meantime, here's another simple and obvious use of rCTE's. No timings because I've not yet had the opportunity.[/quote-0]
Table Spool mania! It doesn't perform 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

November 1, 2010 at 7:13 am

#1244799
RE: Calculating interest query

Paul White NZ (2/27/2010)
...recursive CTEs can be fast, but it is relative. I sometimes use them to seek down the distinct keys of a large index rather than scanning...
^{“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 29, 2010 at 10:04 am

#1244306
RE: Today's Random Word!

Pumpkin.
^{“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 29, 2010 at 9:13 am

#1244266
RE: Today's Random Word!

Ray K (10/29/2010)
All this talk about exotic food -- any Andrew Zimmern fans here?
Was he anything to do with this[/url]?
^{“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 29, 2010 at 8:09 am

#1244216
RE: Today's Random Word!

tosscrosby (10/29/2010)
There's a "roach coach" that serves West African food near my place of employment. The goat was fantastic. The beef skin - not so much.....I expected fried...
^{“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 29, 2010 at 7:55 am

#1244204
RE: Today's Random Word!

Not another biltong post? Yes it is.
If you're in the Leamington area, Kate in the Rustic Deli has today received a shipment of kudu biltong. Nom nom nom. Oh yes....
^{“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 29, 2010 at 7:33 am

#1244177
RE: using group by and count together.

SwePeso (10/29/2010)
SELECTSUM(1) AS Items
FROMdbo.tblHhiQuotes
WHERE sGlDate <= '28 Oct 2010'
AND sEffectiveDate BETWEEN '01 Nov 2010' AND '30 Nov 2010'
AND cTransType...
^{“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 29, 2010 at 5:40 am

#1244069
RE: using group by and count together.

Oops...that's what happens when you don't test. Didn't have SQL Server handy yesterday. Try this:
SELECT COUNT(*)
FROM (
SELECT 1 AS aMatchingRow
...
^{“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 29, 2010 at 5:39 am

#1244068
RE: using group by and count together.

BenWard (10/29/2010)
And the results are in !
My query was the slowest (as was expected lol)
most common speed 156ms with a low of 141 and a high of 196
3rd place...
^{“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 29, 2010 at 4:58 am

#1244048
RE: Add Space between text and number in same field

andrewd.smith (10/27/2010)
Here's another solution using PATINDEX and STUFF.
EDIT: Just noticed my solution was identical to Chris Morris' so have removed it.
Andrew I'm gonna 'fess up mate my solution 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 29, 2010 at 2:41 am

#1244017
RE: Are the posted questions getting worse?

Alvin Ramard (10/28/2010)
WayneS (10/28/2010)
Craig - I see you came through on your threat of a ST avatar! Seems appropriate, especially in the thread with Joes latest rant.
I guess a new...
^{“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 29, 2010 at 2:24 am

#1244012
RE: Today's Random Word!

Plumber
^{“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 29, 2010 at 2:12 am

#1244008
RE: Today's Random Word!

tosscrosby (10/25/2010)
Brandie Tarvin (10/25/2010)
biscuit
Our dog's name (a golden lab). She is sweet!
It's pretty much guaranteed to be a golden lab's favourite food 😛
^{“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 25, 2010 at 6:40 am

#1241536
RE: Need DateTime format and count of records

CREATE TABLE #Sample (MyStuff VARCHAR(22))
INSERT INTO #Sample (MyStuff)
SELECT '13/01/2010(DD/MM/YYYY)' UNION ALL
SELECT '01/13/2010(MM/DD/YYYY)' UNION ALL
SELECT '14/04/2001(DD/MM/YYYY)' UNION ALL
SELECT '11/03/2002(MM/DD/YYYY)' UNION ALL
SELECT '2010/01/01(YYYY/MM/DD)'
SELECT RIGHT(MyStuff, 12), COUNT(*)
FROM #Sample
GROUP BY RIGHT(MyStuff, 12)
^{“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 25, 2010 at 6:34 am

#1241533
RE: Determine 4 working days from Start Of Month

If the first day of the month is 'saturday', add 5 days. If it's a 'sunday', add 4 days. What if it's wednesday?
-- How might this work longhand?
DECLARE @MyDate DATETIME
SET...
^{“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 25, 2010 at 5:42 am

#1241503

Viewing 15 posts - 7,126 through 7,140 (of 10,143 total)