ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,101 through 8,115 (of 10,143 total)

RE: GETDATE in WHERE Clause

rburke 87921 (3/10/2010)
Hi Lynn - thanks for that but I still get no rows returned even though there is a record with the date 2010-03-10 in the order date field....
^{“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, 2010 at 2:35 am

#1131210
RE: Today's Random Word!

CirquedeSQLeil (3/9/2010)
I guess that psychic helmet I bought is working correctly then. 😀
Beedeebeedeebeedee
I guess I spelled it wrong - is it Twiggy or Twiki?
Aha, I think you mean this Twiki.
"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, 2010 at 2:16 am

#1131205
RE: Today's Random Word!

CirquedeSQLeil (3/9/2010)
Twiggy
ROFLMFAO!!!!!
That was my knickname in school!
^{“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, 2010 at 10:06 am

#1130784
RE: Today's Random Word!

CirquedeSQLeil (3/8/2010)
Besides, the MCP made me do it.
Who? Oh, the Master Control Program :blink:
^{“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, 2010 at 2:11 am

#1130504
RE: Using Start and End dates to create a number of months column

Paul White (3/6/2010)
Chris,
Wherever did you get the idea to use an alias name of iTVF?
:laugh:
Paul
Hey Paul, it was from a great article I was reading last week - about transgenderism...
^{“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, 2010 at 2:32 am

#1129879
RE: Using Start and End dates to create a number of months column

Debbie Edwards (3/5/2010)
Ooooh the first one brings bacl 12 rows and the next one brings back 9 rows.
Im going to have a look at both of them. I need 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 5, 2010 at 6:45 am

#1129132
RE: Using Start and End dates to create a number of months column

Peter Brinkhaus (3/5/2010)
Do you mean you have 140 almost identical query's UNIONed together? Try this one:
Oops...sorry Peter.
^{“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 5, 2010 at 6:37 am

#1129126
RE: Using Start and End dates to create a number of months column

This would do it:
SELECT r.Registration_ID, r.[Person_ID], r.Start_Date_Registration, iTVF.MonthNum AS Duration,
CASE WHEN iTVF.[Date Point] < ISNULL(r.[Registration End Date], GETDATE())
THEN iTVF.[Date Point] ELSE NULL END
FROM Test_Registrations r
CROSS APPLY(
SELECT MonthNum, [Date Point]...
^{“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 5, 2010 at 6:35 am

#1129122
RE: Are the posted questions getting worse?

Jack Corbett (3/5/2010)
For those not on Twitter, I passed the 70-432 Implementing and Maintaining SQL Server 2008 exam yesterday. Easier than I thought it would be. If...
^{“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 5, 2010 at 6:07 am

#1129107
RE: Today's Random Word!

mbricker-600840 (3/4/2010)
Cat atrophy.....
What happens when you cat doesn't get enough exercise.
Mike
Dimensional transmogrifier. A truck - turns 3 dimensional cats into 2 dimensional ones.
^{“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 4, 2010 at 9:02 am

#1128551
RE: Today's Random Word!

jcrawf02 (2/25/2010)
CirquedeSQLeil (2/25/2010)
crookj (2/25/2010)
CirquedeSQLeil (2/25/2010)
pre-planning
As we used to say in the Military.... (6 Ps)
P - P - P - P - P - P
(Prior Planning Prevents Piss Poor Performance)
Joe
Planning -...
^{“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 4, 2010 at 6:44 am

#1128476
RE: Update with join - Problem with null in where clause

Haven't you looked to see what you're updating?
select a.comments1a, b.Subdivision
From Notes a
inner join CowettaCoSubs b
on a.account_id = b.account_id
where a.comments1 is null
^{“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 4, 2010 at 6:28 am

#1128467
RE: Confused with "Order by" output

SELECT *, (SELECT COUNT(*) FROM @temp T2 WHERE T1.Phn = T2.Phn)
FROM @temp T1
ORDER BY (SELECT COUNT(*) FROM @temp T2 WHERE T1.Phn = T2.Phn) DESC, ID ASC
^{“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 4, 2010 at 5:54 am

#1128430
RE: Calculating Moving Averages with T-SQL

Gabriel P (3/3/2010)
Comments posted to this topic are about the item <A HREF="/articles/Moving+Average/69389/">Calculating Moving Averages with T-SQL</A>
Excellent article, Gabriel. I reckon it's time to start messing with those pesky CTE'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 4, 2010 at 2:27 am

#1128348
RE: Are the posted questions getting worse?

john.arnott (3/3/2010)
RBarryYoung (3/2/2010)
Paul White (3/2/2010)
CirquedeSQLeil (3/2/2010)
NFL Football team
And I would (genuinely) guess at Chicago. But why ask about the Bears?
It's a meme isn't it. I was never any...
^{“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 4, 2010 at 2:18 am

#1128343

Viewing 15 posts - 8,101 through 8,115 (of 10,143 total)