ChrisM@Work

Forum Replies Created

Viewing 15 posts - 226 through 240 (of 10,143 total)

RE: Mixed Joins

Force the join between B and C to take place first, and you change the result:
SELECT *
FROM TABLE_A
LEFT JOIN TABLE_B
INNER JOIN TABLE_C
ON TABLE_B.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

November 7, 2018 at 3:36 am

#2012664
RE: Execute a Stored Procedure against every row insert in Table

azhar.iqbal499 - Wednesday, November 7, 2018 1:46 AM
Actually I am working over Drilling Software which insert 1 row a into a table...
^{“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

November 7, 2018 at 1:54 am

#2012655
RE: Execute a Stored Procedure against every row insert in Table

azhar.iqbal499 - Tuesday, November 6, 2018 1:50 AM
It is the business requirement to call the SPs against each Row. I am thinking...
^{“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

November 6, 2018 at 2:52 am

#2012496
RE: Group By in a sub query

Jeff Moden - Monday, November 5, 2018 9:04 AM
drew.allen - Monday, November 5, 2018 7:32 AM
^{“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

November 5, 2018 at 9:08 am

#2012410
RE: Group By in a sub query

solus - Monday, November 5, 2018 3:18 AM
I'm trying to use the GROUP BY clause in a sub query that's part 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

November 5, 2018 at 8:12 am

#2012401
RE: need help in creating function

Something like this:
SELECT
[RowIsValid] = CASE
  WHEN AFG = 'Yes' OR [Type] = 'N/A' THEN 1
  WHEN AGF = 'No' OR [Type] = 'Phys' THEN 2
  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

October 31, 2018 at 7:00 am

#2011830
RE: Update and Calculate FIFO

Hamid-Sadeghian - Tuesday, October 30, 2018 4:09 AM
ChrisM@Work - Tuesday, October 30, 2018 3:55 AM
^{“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

October 30, 2018 at 10:49 am

#2011719
RE: Update and Calculate FIFO

Hamid-Sadeghian - Tuesday, October 30, 2018 12:15 AM
Hi ,
I have a table that I want to calculate FIFO and update each price...
^{“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

October 30, 2018 at 3:55 am

#2011647
RE: Can't remove multiple char(32) strings

Jeff Moden - Monday, October 29, 2018 6:42 AM
ChrisM@Work - Monday, October 29, 2018 3:19 AM
^{“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

October 29, 2018 at 7:03 am

#2011514
RE: Can't remove multiple char(32) strings

Jeff Moden - Friday, October 26, 2018 9:05 AM
ChrisM@Work - Friday, October 26, 2018 6:59 AM
^{“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

October 29, 2018 at 3:19 am

#2011489
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Friday, October 26, 2018 6:59 AM
I think that the root problem is simply "just because you can do...
^{“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

October 26, 2018 at 7:13 am

#2011332
RE: Can't remove multiple char(32) strings

A simple test harness shows that the method works:
;WITH
^{“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

October 26, 2018 at 7:10 am

#2011329

RE: Can't remove multiple char(32) strings

Unusually complicated for a simple update:

UPDATE dbo.clean_hotelbookings

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

October 26, 2018 at 6:59 am

#2011323

RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, October 26, 2018 6:16 AM

GAH.

I hate having a SSIS package fail and fail again when being run from...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

October 26, 2018 at 6:48 am

#2011319

RE: NOT IN vs NOT EXISTS

dmbaker - Thursday, October 25, 2018 7:13 AM

I have seen it said that EXISTS/NOT EXISTS can be faster because it can "short...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

October 26, 2018 at 2:17 am

#2011302

Viewing 15 posts - 226 through 240 (of 10,143 total)