Forum Replies Created
Viewing 15 posts - 166 through 180 (of 10,143 total)
-
RE: SQL Query Modification Request
carlton 84646 - Friday, December 21, 2018 6:28 AMChrisM@Work - Friday, December 21, 2018 6:20 AMRE: SQL Query Modification Request
carlton 84646 - Friday, December 21, 2018 6:16 AMChrisM@Work - Friday, December 21, 2018 6:12 AMRE: SQL Query Modification Request
carlton 84646 - Friday, December 21, 2018 6:09 AMThe expected results should look like the following:
This will only take moments...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Help Needed in Date logic
DECLARE @AppDate DATETIME = '2014-01-01'SELECT
[Month] = UPPER(LEFT(DATENAME(month,StartDate),3)),
StartDate,
[enddate] = CAST(EOMONTH(StartDate) AS DATETIME)
FROM (
SELECT TOP(DATEDIFF(MONTH, @AppDate, GETDATE())+1)
StartDate = DATEADD(MONTH, ROW_NUMBER() OVER(ORDER BY (SELECT...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Run away logical reads on stored proc causing timeouts.
With a lengthy output column list and only a few rows in the result set, this query is made for a key lookup using a skinny index to pack as...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Hi Team , Please help.. I have data in one table based on same id we have data some specific column i need to get first NOT NULL value . Incase in 1st row NULL second row 200 3rd roe 300 we have i need to select second row 200 only.
DBA.A - Monday, December 17, 2018 6:56 AM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Hi Team , Please help.. I have data in one table based on same id we have data some specific column i need to get first NOT NULL value . Incase in 1st row NULL second row 200 3rd roe 300 we have i need to select second row 200 only.
DBA.A - Monday, December 17, 2018 5:02 AM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: COALESCE Issues when controlling logic in a tvf
Try this, Steve. I've done something similar before:
SELECT MySecurityToken = COALESCE(d.c1, x1.c2, x2.c3, x3.c4)
FROM (SELECT c1 = MAX(something) FROM Table1) d
OUTER APPLY (SELECT c2 = MAX(something)...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: TOP vs Max/Min: Is there a difference?
Mike, the more complex plan with nested loops etc is associated with the way you've chosen to assign the query result to the variable, not to the TOP operator itself.“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Can it be improved again?
Run the two UNIONed queries separately to confirm that it’s the lower one which is the pain point. Assuming it is, strip away the...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Can it be improved again?
-- Step 1: replace all of the subqueries with their APPLY equivalent:
SELECT
d.part_code,
x1.part_desc,
x2.specification,
d.odr_ref, d.dbcode, crcode,
d.ref_no, d.date, d.source, d.unit_cost,...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Logical Drives on a Solid State Platter
Jeff Moden - Monday, December 10, 2018 8:27 PM
