ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,381 through 7,395 (of 10,143 total)

RE: Average without zero

DROP TABLE #Sample
CREATE TABLE #Sample (Machine INT, Goal INT)
INSERT INTO #Sample (Machine, Goal)
SELECT 111, 0 UNION ALL
SELECT 112, 0 UNION ALL
SELECT 113, 800 UNION ALL
SELECT 114, 810
SELECT AVG(d.Goal)
FROM (
SELECT Machine...
^{“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 16, 2010 at 10:18 am

#1222333
RE: Returning Row Counts From Procedure?

It's probably how you are calling the sp. Try this in a query window:
alter Procedure InsertInstMain(@JobKey Int, @Rows Int Output, @Errors Int Output)
As
SET NOCOUNT ON
--I am trying to populate the...
^{“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 16, 2010 at 10:02 am

#1222313
RE: Today's Random Word!

crookj (9/16/2010)
Chris Morris-439714 (9/16/2010)
crookj (9/16/2010)
Chris Morris-439714 (9/16/2010)
Joe, is your middle name "The"?
😀
I have been called the works. In fact - I use this quote sometimes when questioned:
Hedley Lamarr: "I want...
^{“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 16, 2010 at 9:13 am

#1222278
RE: Today's Random Word!

crookj (9/16/2010)
Chris Morris-439714 (9/16/2010)
Joe, is your middle name "The"?
😀
I have been called the works. In fact - I use this quote sometimes when questioned:
Hedley Lamarr: "I want rustlers, cut throats,...
^{“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 16, 2010 at 9:06 am

#1222266
RE: Today's Random Word!

Joe, is your middle name "The"?
^{“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 16, 2010 at 8:53 am

#1222251
RE: Are the posted questions getting worse?

Brandie Tarvin (9/16/2010)
Paul White NZ (9/16/2010)
Brandie Tarvin (9/16/2010)
I don't know. I read his apology like a passive-aggressive slap upside the head. "Yes, I'm apologizing, but only because I got called...
^{“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 16, 2010 at 7:31 am

#1222178
RE: Syntax for creating a table on the fly

Joe Contreras-290946 (9/16/2010)
Hi,
I can't remember the exact syntax on creating a table that doesn't exists using SQL. Can someone help out.
SELECT firstname,lastname [NEWTABLENAME] FROM Employees
Not sure if that's the...
^{“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 16, 2010 at 7:19 am

#1222162
RE: Finding the two highest values for a criteria

Jeff Moden (9/16/2010)
FelixG (9/16/2010)
Thanks a lot Jeff, I'm coming from SQL Server 2000 and did not have knowledge about rownumber().
I said "performance is vital" to avoid the use of...
^{“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 16, 2010 at 7:15 am

#1222156
RE: Changing from INSERT INTO...SELECT (with a UNION) to SELECT INTO

Robert Frasca (9/14/2010)
In this case, I'm simply trying to switch from a fully logged "INSERT INTO..SELECT" to a minimally logged "SELECT INTO...".
Typically, how many rows are returned by...
^{“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 16, 2010 at 7:06 am

#1222149
RE: Need for right and left outer join

The only time I ever encountered a requirement for both was a hypothetical question in an interview a few years ago. If I see RIGHT JOIN in a query I've...
^{“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 16, 2010 at 6:44 am

#1222133
RE: I want optimize the store procedure-It's take more time to excecute by use while loop

s.chandrahasan (9/16/2010)
Hi ,
first many thanks for ur reply !!!
I tried but i can't do ,
can u please post again your code for my updated code...
^{“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 16, 2010 at 5:05 am

#1222062
RE: I want optimize the store procedure-It's take more time to excecute by use while loop

s.chandrahasan (9/16/2010)
can u please check below one and advise me
how to avoid while loop in this below case :
Sure.
This set of statements performs the same action as...
^{“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 16, 2010 at 2:51 am

#1221996
RE: Are the posted questions getting worse?

Alvin Ramard (9/16/2010)
Beer is good, but great God people are crazy. 🙂
^{“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 16, 2010 at 2:22 am

#1221981
RE: Are the posted questions getting worse?

Alvin Ramard (9/15/2010)
CirquedeSQLeil (9/15/2010)
jcrawf02 (9/15/2010)
bitbucket-25253 (9/15/2010)
By the way for some reason going down is always slower and harder than going up.
Couldn't have anything to do with the fact that 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

September 16, 2010 at 2:10 am

#1221976
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/15/2010)
Brandie Tarvin (9/15/2010)
[font="Verdana"]We're sorry. The user you are attempting to contact has been smited for biltong blasphemy. Please try your post again later.[/font]
[font="Verdana"]We're sorry. The user you are attempting...
^{“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 15, 2010 at 9:49 am

#1221475

Viewing 15 posts - 7,381 through 7,395 (of 10,143 total)