ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 10,143 total)

RE: Help with a query....

SELECT CAST(0 AS DATETIME) -- = '1900-01-01 00:00:00.000': 0 expressed as a date, the base year, see
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/3b078d5b-526c-4884-906a-e4442805795f.htm
-- what day of the week is the base date?
SELECT DATENAME(dw, CAST('1900-01-01 00:00:00.000'...
^{“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

June 16, 2010 at 8:26 am

#1181018
RE: Today's Random Word!

jcrawf02 (6/16/2010)
Chris Morris-439714 (6/16/2010)
Today's Random Worm!
The Velvet worm.
I should've known better than to click on that while eating breakfast.
Jon, think of the benefit - a new way 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

June 16, 2010 at 7:03 am

#1180938
RE: Today's Random Word!

Today's Random Worm!
The Velvet worm.
^{“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

June 16, 2010 at 6:52 am

#1180928
RE: Cross Referencing Tables

Paul_Harvey (6/16/2010)
Thanks very much for your assistance, Chris. That works great.
I prefer to use query 2, as I can understand it. I am not too sure on how...
^{“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

June 16, 2010 at 2:27 am

#1180812
RE: Are the posted questions getting worse?

Paul White NZ (6/16/2010)
We scored a goal and drew!!!!
WOOT!
:w00t:
Thanks to everyone that posted congratulations. 🙂
I'm thinking Italy should be no problem now. Do they even play football/soccer over there...
^{“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

June 16, 2010 at 2:20 am

#1180808
RE: Mentor

scott.pletcher (6/15/2010)
Jeff, you can over-engineer, I'll give you that. Huge amounts of wasted I/O to no purpose. But you feel good about it, and obviously for you that'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

June 15, 2010 at 8:51 am

#1180484
RE: TRICKY SQL QUERY

Garadin (6/14/2010)
Martin,
Chris was suggesting this book:
http://www.amazon.co.uk/Microsoft-SQL-Server-2008-Dummies/dp/0470224657 You can pick it up online. You can also get all of the books I listed on Amazon.
The Understanding and using APPLY...
^{“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

June 15, 2010 at 2:27 am

#1180252
RE: Today's Random Word!

Itching
^{“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

June 15, 2010 at 2:22 am

#1180249
RE: STRINGS - Common portion of a string within a group....

Yeah that's awesome, thanks Steve.
This is what I'd do: break each string into words (as columns) using the string-splitter of your choice. First delimiter is space-backslash-backslash, subsequent delimiters are backslash....
^{“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

June 14, 2010 at 9:08 am

#1179936
RE: Are the posted questions getting worse?

Edit: job done. Thanks Gail.
^{“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

June 14, 2010 at 8:47 am

#1179914
RE: STRINGS - Common portion of a string within a group....

Hi Steve
Any chance of laying this out visually, mate? I reckon I know what you mean, but a picture would really help.
Cheers
ChrisM
^{“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

June 14, 2010 at 8:30 am

#1179898
RE: Mentor

scott.pletcher (6/14/2010)
Jeff has made two significant points here, that the challenges are unrepresentative of real-world coding and also that they may not be the best means to advance the capabilities...
^{“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

June 14, 2010 at 8:24 am

#1179890
RE: Mentor

scott.pletcher (6/14/2010)
Sigh. Consistently all you want to offer is pompous air.
Perhaps you could a few more self-important quotes to your signature so that you could acutally take up 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

June 14, 2010 at 7:55 am

#1179868
RE: Split table on columns into two tables.

sandesh.nagaraj (6/14/2010)
Thanks.Can we solve the problem 1 with a single t-sql statement?
I don't think so, there's only one target of an INSERT INTO or INTO...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

June 14, 2010 at 7:13 am

#1179835
RE: Split table on columns into two tables.

Nice 🙂
Laying out the table structures and the insert statements has encouraged you to do almost all of the work.
You could answer question 1 like this:
-- problem 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

June 14, 2010 at 6:34 am

#1179810

Viewing 15 posts - 7,801 through 7,815 (of 10,143 total)