ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,906 through 7,920 (of 10,143 total)

RE: Today's Random Word!

Too late
^{“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

May 19, 2010 at 10:10 am

#1169573
RE: Today's Random Word!

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

May 19, 2010 at 10:05 am

#1169562
RE: Today's Random Word!

Young's modulus
^{“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

May 19, 2010 at 9:42 am

#1169527
RE: Today's Random Word!

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

May 19, 2010 at 6:54 am

#1169391
RE: update not applying

bodhilove (5/16/2010)
When I backup and restore the database on the same instance and run the query it works.
So, after you backup and restore, it works. Then what? It's working, then...
^{“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

May 19, 2010 at 5:44 am

#1169341
RE: Today's Random Word!

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

May 18, 2010 at 7:59 am

#1168828
RE: Reporting Spam

Dave Ballantyne (5/18/2010)
Reporting a single post in a thread seems to report the whole thread as spam
example
http://www.sqlservercentral.com/Forums/FindPost923257.aspx
Reported as spam.
^{“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

May 18, 2010 at 2:18 am

#1168640
RE: Today's Random Word!

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

May 18, 2010 at 2:11 am

#1168631
RE: Are the posted questions getting worse?

jcrawf02 (5/14/2010)
Chris Morris-439714 (5/14/2010)
Paul White NZ (5/14/2010)
CirquedeSQLeil (5/13/2010)
Thanks Gianluca. I particularly like how Paul handled this...
You would have loved my first draft reply 😉
Celko is undoubtedly a reasonably bright...
^{“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

May 14, 2010 at 9:46 am

#1167643
RE: Top 1 by group query

Hi Peter
Have a look at the output from this SELECT. If the row containing 1 for ChosenRow is the row you want to keep, then rewrite the SELECT including only...
^{“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

May 14, 2010 at 9:17 am

#1167621
RE: Are the posted questions getting worse?

Paul White NZ (5/14/2010)
Chris Morris-439714 (5/14/2010)
Anybody with the initials JC is doomed to have uncompetitive people skills but this guy really takes the biscuit. The last few days he's been...
^{“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

May 14, 2010 at 7:50 am

#1167538
RE: Are the posted questions getting worse?

GilaMonster (5/14/2010)
Chris Morris-439714 (5/14/2010)
Anybody with the initials JC is doomed to have uncompetitive people skills but this guy really takes the biscuit.
Apparently he's actually a very nice guy and...
^{“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

May 14, 2010 at 7:46 am

#1167534
RE: Are the posted questions getting worse?

Paul White NZ (5/14/2010)
CirquedeSQLeil (5/13/2010)
Thanks Gianluca. I particularly like how Paul handled this...
You would have loved my first draft reply 😉
Celko is undoubtedly a reasonably bright individual, but his...
^{“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

May 14, 2010 at 7:07 am

#1167505
RE: Appending insert queries using semicoln

sabarish (5/14/2010)
Hi Everyone ,
I need to insert about 20 records to a database table.... Which is the better approach -
1) inserting one record at a time
2)...
^{“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

May 14, 2010 at 4:38 am

#1167417
RE: Subquery returns more than 1 value

CREATE PROCEDURE USP_UPDATESAL
@DPID INT
AS
UPDATE Humans
SET SAL = CASE deptid
WHEN 10 THEN 40000
WHEN 20 THEN 38000
WHEN 30 THEN 10000
WHEN 40 THEN 0
WHEN 50 THEN -1
END
WHERE deptid...
^{“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

May 14, 2010 at 3:43 am

#1167399

Viewing 15 posts - 7,906 through 7,920 (of 10,143 total)