ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,386 through 8,400 (of 10,143 total)

RE: Get the Maximum value for a Row

htilburgs (12/8/2009)
What do you mean?
I just expand [1], [2] until [31] (for days of month)???
Because this was how we started, but I liked the [1] till [31] to be dynamic.
Or...
^{“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

December 8, 2009 at 7:18 am

#1089208
RE: Get the Maximum value for a Row

htilburgs (12/8/2009)
Like the results from the first answer.
Application123456.......31 MaxUsage
Office2003433000....... x 4
Telebanking232000....... x 3
Erm...this is the result from 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

December 8, 2009 at 5:57 am

#1089145
RE: looking for help to get rid of my cursor

Hi David
This implies that you can only update one column, of one row, per statement - is this correct or am I missing the point somewhere? If it is 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

December 8, 2009 at 5:56 am

#1089140
RE: Get the Maximum value for a Row

That's no good is it! How do you want it to look?
^{“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

December 8, 2009 at 5:41 am

#1089132
RE: Get the Maximum value for a Row

Is this different to your original output?
^{“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

December 8, 2009 at 5:24 am

#1089123
RE: Get the Maximum value for a Row

No problem - read this, it will show you how it's done.
^{“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

December 8, 2009 at 2:36 am

#1089072
RE: Need to eliminate duplicate entries

Mohamed Asane (12/7/2009)
only if all the columns are contain the same value..
They are, aren't they?
^{“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

December 8, 2009 at 2:13 am

#1089068
RE: Where can we use SUB QUERY and JOIN?

Britto (12/7/2009)
Hi Chris,
I am not an expert on Performance tuning. We are using so many views with JOINs in many places, irrespective of table size.
Application is too slow, even though...
^{“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

December 8, 2009 at 2:11 am

#1089067
RE: how to combine two queries in sql server

jprabha.d (12/7/2009)
If i run your quey ,i get a constant values for the column MemoryPages_1
say for any dateTime ,the column values seems to be the same..
[MemoryPages MemoryAvailableBytes ProcessorTIme Datetime MemoryPages_1
9.948098824...
^{“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

December 7, 2009 at 9:38 am

#1088676
RE: how to combine two queries in sql server

How many readings do you have per day?
^{“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

December 7, 2009 at 7:45 am

#1088534
RE: Where can we use SUB QUERY and JOIN?

Britto (12/7/2009)
Hi,
I am having a doubt regarding the appropriate use of SUB QUERY and JOIN.
Please tell me the usage of these techniques, exact place in SQL query which will give...
^{“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

December 7, 2009 at 6:53 am

#1088494
RE: Odd results returned from case statement when date is null

CASE WHEN datewritten IS NULL THEN getdate() ELSE @datewritten END
^{“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

December 7, 2009 at 6:41 am

#1088487
RE: Get the Maximum value for a Row

The pivot operator requires the new output columns to be described and mapped, but if they are not known at run-time the dynamic sql can be used to create 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

December 7, 2009 at 5:39 am

#1088453
RE: Need to eliminate duplicate entries

SELECT DISTINCT *
INTO #TABLEB
FROM #TABLEA
SELECT No, Name
INTO #TABLEB
FROM #TABLEA
GROUP BY No, Name
^{“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

December 7, 2009 at 5:13 am

#1088446
RE: Get the Maximum value for a Row

Try this:
SELECT d.*, s.MaxUsage
FROM (
SELECT [Application], [1] AS Day1, [2] AS Day2, [3] AS Day3, [4] AS Day4, [5] AS Day5, [6] AS Day6
FROM
(SELECT [Application], [Lastname], Daynr
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

December 7, 2009 at 4:38 am

#1088436

Viewing 15 posts - 8,386 through 8,400 (of 10,143 total)