Forum Replies Created
Viewing 15 posts - 541 through 555 (of 10,143 total)
-
RE: Trying to speed up this 'GetWorkingDays' function.
Lars - or this:
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 Moden -
RE: Sum of last 9 records
seubanks00 - Friday, October 20, 2017 8:24 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 Moden -
RE: Trying to speed up this 'GetWorkingDays' function.
Jason A. Long - Wednesday, October 18, 2017 6:00 PM“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 Moden -
RE: Stock take FiFo conundrum
Dom Horton - Wednesday, October 18, 2017 5:16 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 Moden -
RE: Stock take FiFo conundrum
Hi Dom, try this, first in English.
In the Stocktake table;
For each product, ordered by seq;
Determine a RangeStart and RangeEnd.
For seq = 1, RangeStart = 1 and...“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 Moden -
RE: Using Date in Where Condition
Jeff Moden - Tuesday, October 17, 2017 5:44 AMChrisM@Work - Tuesday, October 17, 2017 5:05 AMRE: Using Date in Where Condition
Jeff Moden - Saturday, October 7, 2017 9:10 PMChrisM@home - Saturday, October 7, 2017 3:25 PMRE: Are the posted questions getting worse?
Luis Cazares - Monday, October 16, 2017 10:00 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: Stock take FiFo conundrum
Dom, can you knock up a table of expected results please? Cheers.
“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: Very challenging TSQL Query
Why choose the hard way? Store 1000, 0.5 and 10 with their correct names on the same row and this becomes trivially easy.
What you are asking - the coding...“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 with Trigger
Is there ever likely to be more than onerow at a time added to the opportunity table? This is important because it willdetermine how the trigger...
“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 with Trigger
Stix83 - Monday, October 16, 2017 6:38 AM
what i 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: Where query time between 6am and 6pm
-- Here's how to get the time portion of your datetime.
-- Note that the TIME function has a parameter, check it
--...
“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: How to get columns which has null's
SELECT
[Result] = REVERSE(STUFF(REVERSE('Columns containing NULL in all three tables: '
+ CASE WHEN SUM(c1) < SUM([RowCount]) THEN 'c1, ' ELSE '' END
+ CASE WHEN...“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 with Trigger
Stix83 - Monday, October 16, 2017 2:10 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 ModenViewing 15 posts - 541 through 555 (of 10,143 total)
