ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,246 through 7,260 (of 10,143 total)

RE: Today's Random Word!

John Rowan (10/4/2010)
Org.....uh, nevermind.
Oh John!
^{“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 4, 2010 at 10:10 am

#1231107
RE: Today's Random Word!

Chasm
^{“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 4, 2010 at 9:23 am

#1231064
RE: How to split name in parts and search them in a column

as-534320 (10/4/2010)
...Since this name could be composed by several parts, how do i split the name in its parts and search from them dinamically?...
This query shows how to split 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 4, 2010 at 7:36 am

#1230994
RE: Today's Random Word!

Purrsuasion
^{“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 4, 2010 at 6:34 am

#1230953
RE: How to split name in parts and search them in a column

What about "J. Smith", "J Smith", "Smith, J" and "Smith, J."; what about "John C. Smith", "John C Smith", "J C Smith", "J. C. Smith".
The endless possibilities can make searching...
^{“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 4, 2010 at 5:32 am

#1230911
RE: Today's Random Word!

Brandie Tarvin (10/4/2010)
RichardDouglas (10/4/2010)
Viking
Warriors.
Armour-piercing bodkins.
^{“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 4, 2010 at 5:06 am

#1230906
RE: Are the posted questions getting worse?

The Dixie Flatline (10/1/2010)
Is anyone else having trouble posting this morning?
Steve, I have an answer for the OP in this thread and it won't post my reply.
Yes, first thing 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 1, 2010 at 8:00 am

#1230199
RE: Are the posted questions getting worse?

Brandie Tarvin (10/1/2010)
GilaMonster (9/29/2010)
Kit G (9/29/2010)
Jack Corbett (9/29/2010)
Why assume that this person is a male?:-P
Because a woman couldn't possibly be wrong and therefore whatever she came up with would work...
^{“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 1, 2010 at 5:26 am

#1230120
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/30/2010)
Grant Fritchey (9/30/2010)
CirquedeSQLeil (9/30/2010)
WayneS (9/30/2010)
CirquedeSQLeil (9/30/2010)
GilaMonster (9/30/2010)
The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither...
^{“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 1, 2010 at 2:28 am

#1230083
RE: Help with Update Query

You don't need to join the CTE back to the source table, you can update it directly:
DROP TABLE #TABLE_1
CREATE TABLE #TABLE_1 (S_NO INT IDENTITY,PRODUCT_NAME VARCHAR(10),PRODUCT_ID INT, COUNT_1 INT DEFAULT 0...
^{“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 1, 2010 at 2:24 am

#1230079
RE: Are the posted questions getting worse?

Craig Farrell (9/30/2010)
*blink*blink*... Wow. Makes me never want to buy one of those books of his.
http://www.sqlservercentral.com/Forums/Topic994925-392-1.aspx
It's just an opinion but "Please stop programming until you have read at least...
^{“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 1, 2010 at 2:23 am

#1230077
RE: Today's Random Word!

John Rowan (9/29/2010)
relief
Lamppost.
Funniest thing I ever saw was a dog taking a leak against a lamppost with exposed live wires. It wouldn't have been funny if the dog was hurt....
^{“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

September 30, 2010 at 6:55 am

#1229576
RE: Today's Random Word!

Ray K (9/30/2010)
WOTD: cat (he came home yesterday, safe and sound!)
Of course. He was testing you. You've learned a little respect.
^{“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

September 30, 2010 at 6:50 am

#1229571
RE: Are the posted questions getting worse?

Jack Corbett (9/29/2010)
So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who goes off and does...
^{“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

September 29, 2010 at 8:33 am

#1229086
RE: Today's Random Word!

Ray K (9/29/2010)
Chris Morris-439714 (9/29/2010)
Ray K (9/29/2010)
tosscrosby (9/29/2010)
Ray K (9/29/2010)
Cat
(as in missing -- he didn't come home last night, which is not like him. Mommy and Daddy...
^{“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

September 29, 2010 at 7:04 am

#1228982

Viewing 15 posts - 7,246 through 7,260 (of 10,143 total)