ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,161 through 8,175 (of 10,143 total)

RE: Please solve this sql query

anshu84onnet (1/27/2010)
how can i explain it to you dear just want to know that mechanism behind execution of that query why any number is returned number of times rows...
Try...
^{“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

January 27, 2010 at 7:15 am

#1109270
RE: Alternate of Row_Number() in SQL 2000

What is the nature of the job? Is it for a report, a one-off migration or part of a business process which could be run at any time?
How many rows...
^{“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

January 27, 2010 at 7:07 am

#1109263
RE: grouping my result set based on the firstname column with all other columns included

klineandking (1/27/2010)
VALUES ('Emanuella','Edet',97,'2009-12-22')
VALUES ('Emanuella','Edet',76,'2009-12-20')
the question is ;
the question is i want to find the average grades based on the name and i want the result to include all other columns,...
^{“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

January 27, 2010 at 6:57 am

#1109252
RE: Not getting desired results

You're welcome Jordon, and thanks for your cooperative effort.
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

January 27, 2010 at 2:16 am

#1109165
RE: Not getting desired results

Yep that makes sense, thanks.
Combine your two subqueries into one, one scan of the tables will almost certainly cost less than two:
SELECT c.crs_id AS id,
...
^{“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

January 26, 2010 at 8:27 am

#1108719
RE: SQL SERVER 2008 Pivot

A squash from your nice terracotta tiled roof 😉
Top work, Jorge. It's good to work with a poster who's prepared to put in some effort, as you have always.
^{“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

January 26, 2010 at 7:41 am

#1108681
RE: Incorrect Data in Report

benreeve007 (1/26/2010)
In this proc it was RoomCode which contained incorrect data in Visual Studio. Running the proc in Management Studio gave the correct data.
The same parameters were used in...
^{“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

January 26, 2010 at 7:38 am

#1108676
RE: Not getting desired results

You mean, include into the report where
Any of the check values is equal to 1
AND
Any of the check values is equal to 0
Is this correct?
Isn't this the same as saying...
^{“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

January 26, 2010 at 7:36 am

#1108671
RE: SQL SERVER 2008 Pivot

You have a closing quotation mark in the wrong place
,
print (@PivotTableSQL)
EXECUTE(@PivotTableSQL)' -- <-- closing quotation mark in the wrong place
which means that the PRINT statement and the EXECUTE statement are...
^{“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

January 26, 2010 at 7:12 am

#1108648
RE: Incorrect Data in Report

Which columns from this query appear to differ between the two client environments?
^{“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

January 26, 2010 at 7:08 am

#1108645
RE: SQL SERVER 2008 Pivot

Why do you still include the local temporary table #sipDimensionPos in your solution? If you were creating it as a filtered subset of the table from which it is derived...
^{“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

January 26, 2010 at 6:46 am

#1108624
RE: Incorrect Data in Report

Hi Ben
Does the stored proc have parameters?
Can you post the stored proc?
^{“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

January 26, 2010 at 6:35 am

#1108613
RE: SQL SERVER 2008 Pivot

Hi Jorge, you're just about there. The sample data obviously doesn't need to be in there, and the preselect which picks up id_CliPadre needs to be changed so that it...
^{“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

January 26, 2010 at 6:22 am

#1108605
RE: Sql Update table

cmoloto-996602 (1/26/2010)
not an easy script but worked thanks.
It's beginner's TSQL, second day of TSQL 101 and you would benefit from spending a little time on it, which you clearly have...
^{“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

January 26, 2010 at 6:18 am

#1108602
RE: SQL SERVER 2008 Pivot

Cool - now plug this new component into your query set in place of the original one which was unordered and giving you dupes.
^{“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

January 26, 2010 at 4:51 am

#1108563

Viewing 15 posts - 8,161 through 8,175 (of 10,143 total)